In this example, two tables containing the top 15 products based on year-to-date and prior year-to-date sales are retrieved into Excel via DAX queries:
- Open the Excel workbook containing the Data Model.
- From the Data tab, click on Existing Connections and select one of the queries used to load the data model. Choose one of the smaller dimension table queries, such as Currency.
Existing Connections - M Queries used to load the Data Model
- Click on Open in the Existing Connections menu and then select Table from the Import Data dialog.
Import Data: The Table option
- An Excel table reflecting the chosen query will be loaded to a worksheet. ...
