Forum Discussion

testuserjm's avatar
testuserjm
New Member
8 years ago
Solved

SharePoint Lookup column value

Hi,  I ma currently getting data from a sharepoint 2010 list. The list has a lookup for location.  I am using Power Bi desktop to build a report based on the location title . When I open the list u...
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    If the column looks up to another SharePoint list, then you need to import that list (along with it's unique ID and form a relationship between the two tables.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

If the column looks up to another SharePoint list, then you need to import that list (along with it's unique ID and form a relationship between the two tables.

kleszczy's avatar
kleszczy
New Member
7 years ago

Hi Greg,


Thanks for the tip, it works great when I expand to new rows.

 

My question is how to do the same when I expand to cell:

1. I have ShP Lists loaded to powerquery

2. I have a lookup column, cells show "List", which I can expand, but I don't want to expand to new row, but "Extract values" in the cell, using for examle ';' sign as a separator

3. PQ extracts the ID, liek for example 45; 67; 97 etc.

4. But I don't want IDs, but values and in this case it can't build the relationship, cause it cant match the values (as there is multiple id separated by ';' sign in each cell).

 

Do you have any idea how to solve it? I wil appreciate your advice.