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

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

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

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Moderator v-yuezhe-msft
Moderator

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

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.