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.
Hi Anonymous - could you please share the advanced editor (M Query) steps. Please replace the URL ("xxx") without hiding all the detail. My thinking is that you are using the wrong path in the SharePoint function you are using.