Analyze in Excel empty

Hi  melpop 

'Manage data model' option in excel will only show the data model when you connect data source in excel. A Data Model is created automatically when you import two or more tables simultaneously from a database. When you import one table, you can select 'add this data to data model'. Refer this article: Advanced Excel - Data Model 

'Analyze in excel' just quotes the dataset from power bi service, not as a single data source, this dataset is come from your .pbix file which has included relationships etc. so it will not be used as a single data source to be added to data model in excel.

Relevant restrictions:

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.