Reply
Frequent Visitor
Posts: 4
Registered: ‎09-14-2018
Accepted Solution

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!


Accepted Solutions
Highlighted
Moderator
Posts: 9,898
Registered: ‎03-10-2016

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.

View solution in original post


All Replies
Highlighted
Moderator
Posts: 9,898
Registered: ‎03-10-2016

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.