Issue regarding power bi report using Lookup column relationships'

[Wani_Muneer]

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?"

[rajendraongole1]

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!

[AgataJ · Accepted solution]

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_Muneer]

You'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

[Wani_Muneer]