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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors