Forum Discussion
Gowtham
10 years agoRegular 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 "O...
- 10 years ago
Gowtham OrderId has unique values and non null ?
ankitpatira
10 years agoCommunity 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.
Gowtham
10 years agoRegular Visitor
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..!!
- gautik929 years agoRegular Visitor
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