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 Anonymous, Did you manage to figure out any variations on performances using either of the two connectors?
Would love to hear yur thoughts :)
cheers
Chris
I'm also interested in reasons why one would choose to connect using odata vs. the SharePoint list link.