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.
Solved! Go to Solution.
Open your data in Edit Query.
To the right of the column will appear the arrows in the red circle.
Click on it.
Now the column contains the value selected in the input step performed on the Sharepoint custom list.
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
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?