Connect Excel to a Power BI data model

1
votes

Is there any way to connect Excel to Power BI Desktop and importing the Data Model to Power Pivot?

With Power BI Publisher for Excel it is possible to connect Excel to Power BI Service and get a live connection, but the data is contained within a Pivot Table. I need to maintain a specific spreadsheet-like layout and it is complicated to create formulas linking to a Pivot Table.

Thanks for helping!

1
excelpowerbi
Have you tried the Analyze in Excel option? docs.microsoft.com/en-us/power-bi/service-analyze-in-excel – Alexis Olson
@AlexisOlson sure did. I get the same functionality as Power BI Publisher for Excel. That is, a Pivot Table. – user882670

1 Answers

0
votes

Unfortunately you can't.

The way to achieve your objective is to import your "raw" Excel data from which you created your pivot table in Excel, and then "re-create" artificially your pivot table in power bi desktop thanks to the query editor and the data model manipulation capabilities.