Forum Discussion
Unable to get data from Sharepoint online List
Most Valuable ProfessionalAre you using the SharePoint Online List connector or are you calling the REST API directly for SharePoint?
Also, what list type is it? I've had numerous issues with Tasks lists.
Treb Gatte | Business Solutions MVP | Power BI Recordings | @tgatte | Blog
Hi,
I have a online sharepoint list which has a specific URL, and with this URL i am trying to make connection (OData connection) to Power BI . But it throwing error.
Shivjeet
v-qiuyu-msftCommunity Support
Hi sdeoghar,
Based on my understanding, you are trying to connect to SharePoint online list via OData feed data source type in the Power BI Desktop but get errors, right?
Based on my test, when we connect to SharePoint online list use OData feed, we need to append _vti_bin/listdata.svc at the end of site URL. For example, the URL of the SharePoint online list is this: https://microsoft.sharepoint.com/teams/Qiuyun01/Lists/list01, then we need to specify the OData URL like this:
In your scenario, please check if the URL is correct. And type the URL without copy and paste. In addition, in Power BI Desktop, there is a OOTB data source type for us to retrieve SharePoint online list, it's SharePoint Online List data source. See:
If you have any question, please feel free to ask.
Best Regards,
Qiuyun YuThank you very much for your wonderful reply.
I tried doing as you said and modified my URL with prefic to it as " _vti_bin/listdata.svc" but I am still getting the same error.
I am using sharepoint 2010, so is there anything to do with version.
Also to modify the URL , do we have to anything from backend or just type the original URL with adding "vti_bin/listdata.svc" at the end and hit connect.
Please advise.
- trebgatte
See this article for more information on using REST with SharePoint 2010. https://msdn.microsoft.com/en-us/library/ff798339.aspx
Treb Gatte | Business Solutions MVP | Power BI Recordings | @tgatte | Blog