Forum Discussion
DataSource.Error: SharePoint Request Failed
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.
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.
That is an impressively large number of records!
Interesting, I am also using a parameter for the SharePoint url.
I am using a parameter for the folder because I was doing dev on local machine and dataset, and testing on different SharePoint sites. It was easier to change parameter value than updating url manually in a bunch of queries and functions.
However, my parameter is hardcoded eg doesn't require anyone to choose it. But will try hardcoding the url and see what happens.
Although this still doesn't explain why it works most of the time, but randomly fails.
