Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

I keep running to this dataflow refresh error "Error: PipelineException: SharePoint: Request failed"

I have been trying to wrap my head around on how to get past this error:

Error: PipelineException: SharePoint: Request failed: . RootActivityId = ....Param1 = PipelineException: SharePoint: Request failed: Request ID: ....


All of our data sources (Excel files) are hosted on Sharepoint. There are only 6 tables in this dataflow, the files being less than 1gb in total size. I am also pulling another 6 smaller data/definition lookup tables (also Excel files hosted on Sharepoint) from a dataflow that has no gateway, while the one that is generating the error has one - and I can't seem to remove the gateway either.


I've tried setting up incremental refresh but that isn't helping because I can't get the dataflow to complete the refresh after setting it up. Anyone know a solution to this problem?

Community Support
Community Support

Hi @olimilo ,


Based on your description, you can try to  clear permissions in data source settings and re-import SharePoint files.


I sometimes refer to the following article on sharepoint restrictions when there are errors in this area.

Avoid getting throttled or blocked in SharePoint Online | Microsoft Docs


If the problem is still not resolved, please provide detailed error information screenshooots and let me know immediately. Looking forward to your reply.

Best Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors