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 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'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.

2 Replies

  • 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.