cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KirBel Frequent Visitor
Frequent Visitor

How to handle SharePoint lookup and choice columns in Power BI?

Hello all

I have a SharePoint list with few lookup and choice type columns. When Power BI reads data from this SharePoint list, these columns show up as [List] and [Record] in Power BI's data model.

 

Is there any guidance on how to handle these lookup columns? Can someone point me  to any blogs or documentation on how to load and handle various SharePoint column data types in Power BI?

 

Thanks a lot in advance.

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
gpiero Member
Member

Re: How to handle SharePoint lookup and choice columns in Power BI?

@KirBel

 

please click on

img3.PNG

then click on your file if you have more than one in your report.

 

Now you should see arrows and [Record] in yellow.

Let me know

 

Regards

5 REPLIES 5
gpiero Member
Member

Re: How to handle SharePoint lookup and choice columns in Power BI?

Open your data in Edit Query.

To the right of the column will appear the arrows  in the red circle.

Cattura.PNG

 

Click on it.

pict1.PNG

 

Click OK

pict2.PNG

 

Now the column contains the value selected in the input step performed on the Sharepoint custom list.

Regards

KirBel Frequent Visitor
Frequent Visitor

Re: How to handle SharePoint lookup and choice columns in Power BI?

Hi @gpiero Thank you for reply. 

I don't see arrows in my column.

Also I see square brackets around List and Record. 

I think it is because SharePoint maintains look up columns as Item_Value;#Item_Id

 

2017-10-16 10_46_02-Clipboard.png

gpiero Member
Member

Re: How to handle SharePoint lookup and choice columns in Power BI?

@KirBel,

pheraps I am wrong.

 

But the picture you put in your post show everything in grey.

 

It means this is the data visualization .

 

Are you sure you opened in Edit Query mode?

gpiero Member
Member

Re: How to handle SharePoint lookup and choice columns in Power BI?

@KirBel

 

please click on

img3.PNG

then click on your file if you have more than one in your report.

 

Now you should see arrows and [Record] in yellow.

Let me know

 

Regards

KirBel Frequent Visitor
Frequent Visitor

Re: How to handle SharePoint lookup and choice columns in Power BI?

Thank you