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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jcapezzuto
Resolver I
Resolver I

Analyze In Excel - Relationships not working

I have two tables in a model with a single direction one-to-many relationship.   When using the Analyze in Excel feature the tables act as if there is no relationship between them.  Filtering does not work, values from both tables in the same pivot table cause Cartsesion results etc.  Is there a setting needed that I'm missing or is this a defect?

1 ACCEPTED SOLUTION
jcapezzuto
Resolver I
Resolver I

Just realized that I didn't have any measures in the pivot table (which behaves differently than not having any measures in a Power BI table).  It works correctly with measures.

View solution in original post

7 REPLIES 7
Anonymous
Not applicable

I am having the same issue with Analyze in excel, 

the above links are not working someone please help. 

 

I have my power bi on the web, when I run analyze in excel it all fine and working but when I try to Analyze in the pivot on excel, the filters are working it showing the entire datasheet. 

 

eg: when I try to select the list of SKUs under a category, it shows all the products in the data. 

 

How can I solve this, How can have the same relationship as power bi on excel? 

 

Please Help!!@

jcapezzuto
Resolver I
Resolver I

Just realized that I didn't have any measures in the pivot table (which behaves differently than not having any measures in a Power BI table).  It works correctly with measures.

Can you elaborate on this.  I'm not getting the relationships setup in PowerBI to work in the Analyze in Excel.

Anonymous
Not applicable

I have the same problem.. relationships are not working??

link is broken...

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.