Retrieving data from SharePoint causing throttling errors
I have a report that gathers data from a bunch of SharePoint files. (In fact, I have a lot of reports that gather data from SharePoint files.) However, this report will be working and then suddenly fail with a SharePoint Request Failed (contextinfo). At the same time, if you visit the SharePoint site, (or any site in my tenancy) you get the throttle message. All other throttling effects happen too, like the inability to upload via OneDrive. It appears to me that the Power Bi requests are causing the throttling issue - has anyone else run into this?
API 15 is already specified, and has been for some time.
This is the limitation that Power BI is triggering. Power BI doesn't report anything other than request failed, but if I visit the site using the credentials used by Power BI, I get the throttle.htm error message.
It maybe a issue with this connector, But sorry for that, We cannot reproduce the issue here and also not found an effective solution. We suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/
Community Support Team _ Dong Li If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Have you found a solution for this? I'm trying to create a report on a SP list with ~30k items and I keep getting throttled. I can pull the data into a report but the problems start when I try to change field types or expand columns (Modified by).