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

     

AgataJ's avatar
AgataJ
Helper 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
Helper 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
    Helper 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