Forum Discussion
Lookup column field from SharePoint list not appearing in PowerBI- best workaround?
My lookup column field from a SharePoint list not appearing in PowerBI- can you suggestr the best workaround? Many thanks!
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-BI/td-p/278109
https://whitepages.unlimitedviz.com/2018/01/using-power-bi-to-report-on-person-fields-in-sharepoint/
Regards,
Lydia
1 Reply
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-BI/td-p/278109
https://whitepages.unlimitedviz.com/2018/01/using-power-bi-to-report-on-person-fields-in-sharepoint/
Regards,
Lydia