Issue while building report from sharepoint multi-select lookup column

[Amitk22]

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 -  

"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]

Hi @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-...

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.

Regards,

Daniel He