Forum Discussion
Analyze in Excel - Data Model Missing in Excel
Hi Anonymous ,
'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
In this issue, '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.
In other words, the dataset itself has been a model, you can manage it in your power bi desktop not in excel to recreate a model.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-yingjl -
Thanks for the clarification, that helps to understand a bit. So please clarify the following then:
1) If the data model is not imported, will all the relationships between the data i have setup in the desktop file work when i pull use it as "Analyze in Excel"?
2) If i want to add any relationship or measure, i have to do that first in Power BI desktop, publish to the service, then it should show up in my excel file?
thanks!
Hi Anonymous ,
- Yes, 'Analyze in excel' quotes the dataset in power bi service, relationships will retain.
- If you want to add relationship or measure, you have to do that first in power bi desktop, then publish to service and re-use 'Analyze in excel', although you cannot see the relationship and concrete formula of the measure, you can only see the table fields and the value of measure in the excel file.
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.