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

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

 

Can anyone help on what is the difference between the two ones? When we should choose one over another?

 

Any comments would be highly appreciated 🙂

1 ACCEPTED SOLUTION
v-yuezhe-msft
Microsoft
Microsoft

@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

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

View solution in original post

5 REPLIES 5
otravers
Continued Contributor
Continued Contributor

I'm posting in this old thread because Google made it the top result for related web searches. The main difference between the two is that using the OData feed is supposed to support query folding according to the documentation:

https://docs.microsoft.com/en-us/power-query/power-query-folding

 

I'm trying to clarify how to check whether that actually works in Power BI Desktop, as the View Native Query option is greyed out right from the Source step (i.e. without doing any transformation that might break query folding).

v-yuezhe-msft
Microsoft
Microsoft

@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

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

View solution in original post

Anonymous
Not applicable

But what about performance?

Would it be better to filter using OData than importing all data from SharePoint.Tables ?

Anonymous
Not applicable

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. 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors