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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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!

v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

  1. Yes, 'Analyze in excel' quotes the dataset in power bi service, relationships will retain.
  2. 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 Li

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