Forum Discussion
Random table gets SHAREPOINT REQUEST FAILED error when refreshing data
Hi. I have created a quite complex Power BI report that uses only 1 type of data sources: Excel files stored in OneDrive for Business. Everything worked fine, but a few days ago I start to get th...
This has been happening from time to time with one of my dataflows which are using
SharePoint.Files(SharePointPath, [ApiVersion = 15]) to retrieve csv files.
I have about 4 other dataflows getting data from same SharePoint folder which are all scheduled at the same time.
However, it is always this one particular dataflow that fails. The others haven't yet.
My error is something like:
Error: DataSource.Error: SharePoint: Request failed: https://mysite.sharepoint.com/personal/my_name/Documents/my_csv/_api/contextinfo Request ID: xxx Activity ID: xxx
After error happens, I can immediately manually refresh this dataflow successfully.
The only thing unique about this particular dataflow compared to about 5 other dataflows is that it includes a merged query on same datasource (does group by to get daily counts and merges them to calculate percentages).
As OP mentioned, it doesn't fail at any particular csv but seems random.
I am wondering if there are some limits being hit behind scenes? Perhaps limit on # hits to SharePoint folder by either SharePoint or by Power BI dataflow? Or limit on # csv files per x unit of time, or per connection instance?
Is there anywhere I could get more details about the error other than the scheduled refresh log?