Forum Discussion
DataSource.Error: SharePoint Request Failed
- Anonymous4 years ago
So to answer to both of 009co and Anonymous , in my M Query i had a parameter where the user would choose which SharePoint folder powerbi would import data from. Today was the first time i was able to refresh data (i deleted some tables and relationships) and it turns out it was importing 20 MILLION rows (and counting). So i deleted the parameter and put the path by hand, like i always do, on the navigation step and it worked perfectly after. I assumed it was because of the parameter but never would've thought it was pulling all the files from my O365 Team. This most likely caused A LOT of calls to SharePoint and thus the error.
Thank you both
Edit: it was actually pulling more than 100M rows, so clearly this could've triggered something.
I found a bypass. Try the solution at: Using the wait-retry pattern in Power Query connectors - Power Query | Microsoft Docs