Forum Discussion

Wani_Muneer's avatar
Wani_Muneer
Icon for Helper I rankHelper 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

     

AgataJ's avatar
AgataJ
Icon for Helper II rankHelper II
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

 

  • Wani_Muneer's avatar
    Wani_Muneer
    Icon for Helper I rankHelper I
    1 year ago

    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's avatar
      AgataJ
      Icon for Helper II rankHelper II
      1 year ago

      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