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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
sagarsahoo_123
Helper IV
Helper IV

Circular Dependency error while creating relationship between two table

Hi All,

Please help me to resolve circular dependency error while creating relationship between two tables.

 

I want to rearrange the below given value in that particular order.

sagarsahoo_123_0-1664438310362.png

But by default it is coming in the below order.

sagarsahoo_123_1-1664438400534.png

To acheive in the right order i created one more Table with this value by entering data and tried to create relationship with the main table. But it is throwing the error given below.

sagarsahoo_123_2-1664438509824.png

In the Above, VW_Nippon_Productivity is my main data table and ILP Effort Matrix table is created for sorting. I want to make relation between ILP Effort Matrix column of main table with "ILPEffortMatrix" column of ILP Effort Matrix table.

 

Any help on this would be highly appreciated.

 

Thanks,

Sagar

2 REPLIES 2
amitchandak
Super User
Super User

@sagarsahoo_123 , If you have created that table from this table try to use distinct on top of it.

 

Example

Distinct(All(Table[Col]))

 

 

Also, in the table shown above you can mark Sorting as a sort column

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hello Amit,

Actually I created a simple table manually by using Enter Data option given image below.

sagarsahoo_123_0-1666179146611.pngsagarsahoo_123_1-1666179167236.png

Then tried to create relationship with main table.But not sure why i am facing circular dependancy error. Tried your given approach as well but it could not solve the problem.

Any thing which i am missing here!Please suggest.

 

Regards,

Sagar

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.