Forum Discussion

Adam13Hylo's avatar
Adam13Hylo
Helper I
9 years ago
Solved

Multiple SharePoint Lookup Columns Relationships

Hi all,

 

I am having trouble and was wondering if someone could please help and advise me. 

 

I have a SharePoint custom list which contains 5 lookup columns all of the same lookup, for example: 

 

 

 

 

 

 

 

 

The issue I have is that all five lookup columns lookup to the same list, I know that in Power BI it is not possible to create relationships like so: 

I am just wondering what the best way to work around this would be as I require to be able to build reports based on the lookup value. 

 

I have already tried a few different methods to get this working but so far had no luck. 

 

Appreciate any help and advice.

 

 

Need Help
Tutorial Requests
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Hi Adam13Hylo,

     

    If we can combine the five columns into one, it will be easy to create relationship.

    1. Open Query Editor;

    2. Select the five columns with "Shift" or "Ctrl";

    3. Click "Unpivot Only Selected Column".

    4. Change column names if needed.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

1 Reply

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    9 years ago

    Hi Adam13Hylo,

     

    If we can combine the five columns into one, it will be easy to create relationship.

    1. Open Query Editor;

    2. Select the five columns with "Shift" or "Ctrl";

    3. Click "Unpivot Only Selected Column".

    4. Change column names if needed.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale