Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
BrunoM
Helper I
Helper I

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

BrunoM_2-1699551781322.png

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.

BrunoM_4-1699552459301.png

 

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 ...

 

BrunoM_3-1699552043289.png

 

What did i forget ?

 

In advance thank you for your help !

1 ACCEPTED SOLUTION
Anand24
Super User
Super User

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.

 

PBI_SuperUser_Rank@1x.png  

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

View solution in original post

3 REPLIES 3
Anand24
Super User
Super User

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.

 

PBI_SuperUser_Rank@1x.png  

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

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?

@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. 

PBI_SuperUser_Rank@1x.png  

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors