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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors