Forum Discussion
BrunoM
Advocate I
Advocate IAnalyze In Excel file does not respect the datamodel
Dear All, i need your help on this problem. I have created an Analyze in Excel file based on a dataset with a simple Star data model : I have a relationship 1 to many between the dimension table A ...
Hi BrunoM ,
When you analyze in excel, each table is considered as a stand-alone table in Excel and no relationships are carried forward to Excel.Yes, this indeed is a drawback currently.
Alternative: Create a single merged table from Power Query in Power BI and then analyze it in excel.
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!
Proud To Be a Super User !!!
LinkedIn
Anand24
Super User
Super UserHi BrunoM ,
When you analyze in excel, each table is considered as a stand-alone table in Excel and no relationships are carried forward to Excel.
Yes, this indeed is a drawback currently.
Alternative: Create a single merged table from Power Query in Power BI and then analyze it in excel.
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! |