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

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

3 Replies

  • Anand24's avatar
    Anand24
    Super User
    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