Forum Discussion
Error in Relationship between Tables
I have encountered an issue with the relationship between two tables in our Power BI report. The tables are already linked, but I noticed a discrepancy when trying to compare data with the table. Specifically, all the columns in the "ORDER" table are showing a red background error.
Hi ginalu ,
As you can see from your table-to-table relationship, if you want to reference the columns in the ORDER table correctly, you should have a one-to-many relationship from the ORDER table pointing to the Plan table.
I have similarly created two tables which are the ORDER table and the Plan table.
If you apply your relationship, you do encounter errors reported during the creation process.
But you can get the correct output if you transform the relationship.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hello ginalu ,
Please make sure you have done the below checking, because looking at the screenshot you have shared it seems there is mistake in relationship.
1. Ensure that the relationship between Order[org_ID] and Plan[Ord_id] is set as a 1-to-many or many-to-1 relationship.
2.Ensure that the org_ID fields in both tables ( ORDER and Plan) have the same data type (e.g., both should be text or both should be numeric).
3. If there are null or blank org_ID values in either table, the Related() function may fail when attempting to pull data.
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!
Thank You
Dharmendar S
Hi ginalu ,
As you can see from your table-to-table relationship, if you want to reference the columns in the ORDER table correctly, you should have a one-to-many relationship from the ORDER table pointing to the Plan table.
I have similarly created two tables which are the ORDER table and the Plan table.
If you apply your relationship, you do encounter errors reported during the creation process.
But you can get the correct output if you transform the relationship.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
