Fetching data from sharepoint large list

[Shuvam-rpa]

Dear community members,

I hope this message finds you well. I am currently working on a project that requires me to retrieve data from a SharePoint list in Power BI. However, I am facing some challenges due to the large number of SharePoint items.

I would greatly appreciate it if any of you could provide me with some guidance on the best way to retrieve data from SharePoint lists in Power BI, especially when dealing with a large number of items. Any tips, suggestions or recommended practices would be highly appreciated.

Thank you in advance for your help and support.

[Shuvam-rpa]

@lbendlin thanks for the solution, could show me with the example??

[lbendlin]

Here's the documentation with examples. You can ignore the auth part since you are (presumably) already authenticated.

Use OData query operations in SharePoint REST requests | Microsoft Learn

[lbendlin]

Use ODATA queries with pagination.