Forum Discussion

Gowtham's avatar
Gowtham
Regular Visitor
10 years ago
Solved

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 "O...
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    Gowtham OrderId has unique values and non null ?

ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

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.

  • Gowtham's avatar
    Gowtham
    Regular Visitor
    10 years ago

    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?

    • ankitpatira's avatar
      ankitpatira
      Community Champion
      10 years ago

      Gowtham OrderId has unique values and non null ?

  • Gowtham's avatar
    Gowtham
    Regular Visitor
    10 years ago

    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..!!

    • gautik92's avatar
      gautik92
      Regular Visitor
      9 years ago

      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