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!
Please follow the guide in the blog below to connect to Power BI Desktop data model from Excel.
Hi @v-yuezhe-msft thank you for your help.
The post describes a method to connect Excel to PBI Desktop, but the data is available in a Pivot Table only, which is basically the same that Power BI Publsher for Excel Add-in does.
I can't think of any other methods to achieve the requirement.
@webportal I'm looking for an answering to the same problem and wondering if you found a solution yet? I would greatly appreciate it if you can share your solution.