Forum Discussion

Wani_Muneer's avatar
Wani_Muneer
Helper I
1 year ago
Solved

Issue 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 relationshi...
4
  • AgataJ's avatar
    AgataJ
    1 year ago

    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

     

rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

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's avatar
    Wani_Muneer
    Helper I
    1 year ago

    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!