Forum Discussion
Solved
Getting data from SharePoint Online List vs OData Feed
Hello! We have two ways to get data from a Sharepoint List (OData Feed and SharePoint Online List) - https://social.technet.microsoft.com/wiki/contents/articles/40040.power-bi-two-way-to-get-data...
mihaela，
There is no obvious difference when you use the two connectors to connect to SharePoint online data source, you can find that in the Navigator of Power BI Desktop, two connectors bring almost same tables, but the table structure can be different. If you want to connect to a specific online list, you can use the OData URL: https://yoursharepointsite/_vti_bin/listdata.svc/ListName.
Regards,
Lydia
Hi, we have wrote a couple of posts regarding SharePoint OData and API connections in Power Query. I hope these links come in handy.
https://www.bibb.pro/post/sharepoint-api-use-in-power-bi
https://www.bibb.pro/post/sharepoint-odata-in-power-query