Forum Discussion
Helper IIssue regarding power bi report using Lookup column relationships'
I have imported all tables from a SharePoint list into Power BI and created relationships between them. The main table uses a real ID column, while other tables use lookup ID columns. The relationships are defined as one-to-many, with the main table's ID column linked to the lookup ID columns in other tables.
When I use data from two tables in a Table visual, it works fine. However, when I add data from a third table, I encounter the error: 'Can't determine relationships between the fields.'
How can I resolve this issue?"
Hi Wani_Muneer ,
Are all the lookup tables linked to the Main Table by ID column? Any chance you could share your schema?
Kind regards,
Agata
6 Replies
AgataJHelper II
Hi Wani_Muneer ,
Are all the lookup tables linked to the Main Table by ID column? Any chance you could share your schema?
Kind regards,
Agata
Wani_MuneerYou're welcome, AgataJ! Here's the corrected and rephrased version of your statement:
"I have lookup tables linked to the main table via the ID column, but I encountered the same error: 'Can't determine relationships between the fields.'".
do you have any solution please share .- AgataJ
Hi Wani_Muneer ,
it is difficult to advise anything without seeing the schema. I'd follow steps provided by rajendraongole1 , if it doesn't help, please provide a screenshot of the schema.
Kind regards,
Agata
- rajendraongole1
Super User
Hi Wani_Muneer - If your model has inactive relationships (dashed lines) or multiple paths between tables, ambiguity can arise.
Check if a relationship is inactive or duplicates another path to connect the tables
Things to cross check at model.
- Selecting the relationship in Model view.
- Enabling the "Make this relationship active" checkbox.
- Delete the existing relationships between the tables.
- Recreate them manually in Model view, ensuring the correct columns are used.
check the above steps in your model and i hope it helps.
- Wani_Muneer
Here's the corrected and rephrased version of your statement:
"I have checked everything in the relationships, and the relationship is active. I have done everything correctly, but I couldn't find a solution. Please help me if you find any new solutions."
Let me know if you need further clarification or assistance!
