Showing results for 
Search instead for 
Did you mean: 
Resolver I
Resolver I

This expression refers to a Partition object, which has an error

Hello All,


I'm getting the following error for one of my tables: This expression refers to a Partition object named 'Pareto Table[Pareto Table-989c836b-2287-4a64-b934-3ad52e6d0776]', which has an error. 


I have 3 tables & their relationships are as follows:


Pareto Table- Data Table: 1:many

Data table - Line Table: 1: Many


Now when I change the relationship between Data Table & Line Table to many:many the issue with Pareto table gets fixed, but I"m not understanding what is causing this. I've been scratching my head for hours and any help would be much appreciated.



Solution Sage
Solution Sage

Hi @SJ25 ,


Have you changed the direction of the relationship while you changed it to many to many?

If not,could you pls upload your .pbix file to onedrive business and share the link with us?Do remember to cover the confidential information.


Best Regards,
Did I answer your question? Mark my post as a solution!

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.


Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.