Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Analyze in Excel - Data Model Missing in Excel

Hi all -  I am trying to use "Analyze in Excel" to bring my Power BI data model out into Microsoft Excel to build reports for my clients ( who prefer to work in Excel). I have successfully saved the...
Need Help
Tips and Tricks
Tutorial Requests
nandic's avatar
nandic
Icon for Resident Rockstar rankResident Rockstar
6 years ago

Hi Anonymous ,
Analyze in Excel allows you to interact with data set from Power BI, but it has only connection to data set, it doesn't have any of data from model.

 

Here is the link: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel
"You can Save the Excel workbook you create with the Power BI dataset, just like any other workbook. However, you cannot publish or import the workbook back into Power BI, because you can only publish or import workbooks into Power BI that have data in tables, or that have a data model. Since the new workbook simply has a connection to the dataset in Power BI, publishing or importing it into Power BI would be going in circles".