Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
My lookup column field from a SharePoint list not appearing in PowerBI- can you suggestr the best workaround? Many thanks!
Solved! Go to Solution.
@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
@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