SharePoint Lookup column value

[testuserjm]

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 using the getdata sharepoint list option. I get the data but the locationid is shown in the list. (i.e. 1,2,3... etc). I need to show the data to be shown as the loction i.e. Paris, New York ....etc. 

I clicked on Edit Queries but i don't the expand or record link for the look up column. 

Is there a way to get the sharepoint lookup title value i.e. Paris instead of their id. 

Regards,

John

[Greg_Deckler · Accepted solution]

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]

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.