Analyze In Excel file does not respect the datamodel

[BrunoM]

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 and the fact table B.

In the report settings of the dataset, i have selected the entry Allow end users tio export data with current layout, summarized data and underlying data.

In the report visual the slicer based on the table A filters as expected the table B.

My problem : in the Analyze in Excel File i use the table A (in the filter part) to filter the table B (in the rows part). As you can see, only one entry is selected in the filter but the rows are not filtered ...

What did i forget ?

In advance thank you for your help !

[Anand24 · Accepted solution]

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]

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]

@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