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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Gowtham
Regular Visitor

Cannot create relationship between two columns.

Hi everyone, I am new to power BI. I connected to an Excel data source and found the relationships between the tables are automatically created. But there was not relationship established bwetween "Oeder" and "OrderDetails" table based on "OrderId".

When i tried to establish the relation manually, it was shown an error message as follows "you cant create a relationship between these two columns because one of the coulmns  have unique values". I searched for this topic in the forum but still couldnt find a solution. I also checked the data and made sure that the "OrderId" column in "Orders" table contains only unique values. Kindly guide me solving this issue..

1 ACCEPTED SOLUTION

@Gowtham OrderId has unique values and non null ?

View solution in original post

5 REPLIES 5
ankitpatira
Community Champion
Community Champion

@Gowtham Can you ensure order ids in table OrderDetails are all present in OrderId table ie there are no values in Orderdetails table that is not present in OrderId table.

@ankitpatira Thanks again for your reply. It was a data issue as there was a NULL value in the OrderId column. Now that has been corrected and I am ablue to create  a relationship..!!

If i am taking Date as Field for relationship it doesnot have unique values and it has duplicate values so can i create a relationship with t

@ankitpatira Thanks for your immediate response. Yes i have checked and made sure that all the OrderId values in OrderDetails Table are in the Orders Table too. What else could possibly be the reason for this error?

@Gowtham OrderId has unique values and non null ?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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