Reply
ginalu
Helper I
Helper I
Partially syndicated - Outbound

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.

 

relation2.pngerror.png

 

 

1 ACCEPTED SOLUTION
v-yilong-msft
Community Support
Community Support

Syndicated - Outbound

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.

vyilongmsft_0-1727230674359.png

vyilongmsft_1-1727230700620.png

If you apply your relationship, you do encounter errors reported during the creation process.

vyilongmsft_2-1727230982430.png

vyilongmsft_3-1727231030233.png

But you can get the correct output if you transform the relationship.

vyilongmsft_5-1727231229265.png

vyilongmsft_4-1727231210109.png

 

 

 

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.

View solution in original post

2 REPLIES 2
v-yilong-msft
Community Support
Community Support

Syndicated - Outbound

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.

vyilongmsft_0-1727230674359.png

vyilongmsft_1-1727230700620.png

If you apply your relationship, you do encounter errors reported during the creation process.

vyilongmsft_2-1727230982430.png

vyilongmsft_3-1727231030233.png

But you can get the correct output if you transform the relationship.

vyilongmsft_5-1727231229265.png

vyilongmsft_4-1727231210109.png

 

 

 

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.

dharmendars007
Super User
Super User

Syndicated - Outbound

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

LinkedIN 

 

 

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)