Forum Discussion

Amitk22's avatar
Amitk22
New Member
7 years ago

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 ...
Need Help
v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

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

 

Regards,

Daniel He