Click Next, Finish, PivotTable Report, OK. Enter the server name and port from step 3 (e.g.

Connecting an Excel pivot table to a Power BI Desktop data model: On the Data tab, click Get Data, From Database, From Analysis Services.

Switch to Excel to see the data – you can now make this a table (Ctrl-T) and/or add it to Power Pivot (Power Pivot tab, Add to Data Model).

Type an evaluate query for a table of interest (see screenshot) and click Run.

From the Home tab, click Output, Excel, Static. localhost:55641 – this is needed in step 4. Note the port number after the localhost server name in the status bar, e.g. In the DAX Studio Connect dialog, click PBI / SSDT Model and click Connect – it should automatically pick up the name of the open pbix file. In Excel, click Add-ins, DAX Studio (you will need to have downloaded and installed the free and wonderful DAX Studio).

Importing a Power BI Desktop data model table into an Excel table: Open the Power BI Desktop pbix file and leave it open.

Importing an Excel Power Pivot data model into a Power BI Desktop data model: Click the drop-down button to the left of the Home tab.

Load takes you straight to report design, Edit invokes Power Query in case you want to do some data transformations.

If a table has the same name as a worksheet, the table will have a numeric suffix (e.g.

Tables have a small blue bar across the top. Once you have chosen the source workbook, you can preview and/or select tables and/or worksheets from the Navigator dialog. Importing an Excel table or worksheet into a Power BI Desktop data model: Click Get Data, Excel.Sometimes, you may also want to view the Power BI Desktop model (or a data model) back in Excel as a pivot table or simply export a table back to Excel. For private training for 3 or more people at your site or online.Įxcel tables or worksheets and Excel Power Pivot are popular sources of data for Power BI Desktop models.

Open power query in excel