Question about filtering data in Power BI

[Anonymous]

werBII have a Power BI report that fetches data from a SharePoint Online list that contains 30000 records or so; this report started failing last year, showing the error "The remote server returned an error: (429). (429 TOO MANY REQUESTS). "

In my report, I have decided to filter data and bring fewer records based on date ranges; I still get the error. Below are the steps I'm using to retrieve and filter my data; I'm looking for a way to filter data in a prior action. Do you happen to know how to do this? 

I want to make a query before getting my data from my source. 

I really appreciate any help you can provide.

[v-kelly-msft]

Hi @Anonymous ,

It's a limitation from Sharepoint endpoint.

When you get a 429 TOO MANY REQUESTS response in SharePoint, you know that you're being throttled. To stop throttling, you must temporarily decrease the number of requests you issue to SharePoint.

Check the reference below:

https://blog.mastykarz.nl/simulating-throttling-sharepoint/#:~:text=When%20you%20get%20a%20429,requests%20you%20issue%20to%20SharePoint.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[AlexisOlson]

I'd guess the basic question would be if the query is folding properly or not. Supposedly, SharePoint lists can do query folding but it also seems like people have had trouble getting it to work.

Is there any difference if you remove those last two steps? They might potentially be breaking the query folding.

[jdbuchanan71]

@Anonymous 

I don't think this is a matter of too large a list being returned.  Take a look at this article from MS that talks about throttling in Sharepoint Online.

https://docs.microsoft.com/en-us/sharepoint/dev/general-development/how-to-avoid-getting-throttled-or-blocked-in-sharepoint-online