Forum Discussion
webportal
Impactful Individual
Impactful IndividualConnect Excel to a Power BI data model
Hello, 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...
Try using macros in Excel. That's the only way I can think of. I don't know too much about macros but I think simple steps like that can be done very easily.
webportalImpactful Individual
Impactful IndividualActually, I've used Power BI connector for Excel add-in with Excel CUBE functions and was able to manipulate the layout of the data in Excel without the Pivot table.
Not so difficult, after all!
😁