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 .