Query Result Data Source. An Excel Data Model is a relational data source composed from multiple tables inside an Excel workbook. In the Export Data dialog click Export to File.
The Query Results Data Source QRDS lets you run queries against results from your other Data Sources. Sources that support folding. In the Excel browse dialog box browse for or type the Products and Ordersxlsx path to import or link to a file.
Query any ODBC data source you have a driver for.
When the data model is refreshed its often assumed that Power Query retrieves the Query1 result and that its reused by referenced queries. An Excel Data Model is a relational data source composed from multiple tables inside an Excel workbook. In the Excel browse dialog box browse for or type the Products and Ordersxlsx path to import or link to a file. In the POWER QUERY ribbon tab click From File From Excel.