Issue while building report from sharepoint multi-select lookup column

Question

Hello,I am using a sharepoint list that has a multi-select lookup field. When I try to expand that column it gives me below error - &nbsp;"DataSource.Error: SharePoint: Request failed: The remote server returned an error: (500) Internal Server Error. (Specified method is not supported.)"I know there were issues in the past with using SharePoint multi-select lookup fields in Power BI but I was woondering if anything had been resolved or if anyone had worked out a resolution.Can anyone provide any update or a resolution (even from the SharePoint side) on how to utilise the multi-select lookup field in Power BI?Cheerrs,Amit

v-danhe-msft · Answer

Hi&nbsp;Amitk22,
What kind of ways you connect your sharepoint list? Based on my research, there are two ways connecting sharepoint list:
https://social.technet.microsoft.com/wiki/contents/articles/40040.power-bi-two-way-to-get-data-from-sharepoint-list-library.aspx
And refering to below issue, it seemd your issuse could be solved with OData Feed:
https://community.powerbi.com/t5/Desktop/Connecting-to-SPO-list-via-OData/td-p/551340
I suggest try again.
&nbsp;
Regards,
Daniel He

Forum Discussion

Issue while building report from sharepoint multi-select lookup column

1 Reply

Related content

Mandatory multi select slicer

Power BI Service report on SharePoint lists with multi-select relationships

Multi selection in power bi

Break out Multi-Select field into Slicer

Sharepoint list mirroring