Solved: Lookup column field from SharePoint list not appea...

Jimeh · ‎09-19-2018

My lookup column field from a SharePoint list not appearing in PowerBI- can you suggestr the best workaround? Many thanks!

Anonymous · ‎09-20-2018

@Jimeh,

Lookup fields will show up as [List] or [Record] in Power BI Desktop, please go to Query Editor of Power BI Desktop and expand the [List] or [Record] column. There are a similar thread and a blog for your reference.

https://community.powerbi.com/t5/Desktop/How-to-handle-SharePoint-lookup-and-choice-columns-in-Power...
https://whitepages.unlimitedviz.com/2018/01/using-power-bi-to-report-on-person-fields-in-sharepoint/

Regards,
Lydia

Anonymous · ‎09-20-2018

@Jimeh,

Lookup fields will show up as [List] or [Record] in Power BI Desktop, please go to Query Editor of Power BI Desktop and expand the [List] or [Record] column. There are a similar thread and a blog for your reference.

https://community.powerbi.com/t5/Desktop/How-to-handle-SharePoint-lookup-and-choice-columns-in-Power...
https://whitepages.unlimitedviz.com/2018/01/using-power-bi-to-report-on-person-fields-in-sharepoint/

Regards,
Lydia

Lookup column field from SharePoint list not appearing in PowerBI- best workaround?