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

Issue while building report from sharepoint multi-select lookup column

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

1 REPLY 1
Community Support Team
Community Support Team

Re: Issue while building report from sharepoint multi-select lookup column

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

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