Forum Discussion

BrunoM's avatar
BrunoM
Advocate I
2 years ago
Solved

Analyze 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 ...
Need Help
  • Anand24's avatar
    Anand24
    2 years ago

    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
BrunoM's avatar
BrunoM
Advocate I
2 years ago

Hi Anand24 ,
Thank you for your answer.
Do you know if Microsoft is planning to correct this and transfer the data model and table relationships to the Analyzed In Excel files?

Anand24's avatar
Anand24
Super User
2 years ago

BrunoM ,
It doesn't seem to be in the Power BI roadmap. 
Link: https://learn.microsoft.com/en-us/power-platform/release-plan/2023wave2/power-bi/planned-features

You can post this as an idea in https://ideas.fabric.microsoft.com/ so that it gets noticed and if it gets enough votes, it might get into the roadmap. 

 

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