Showing results for 
Search instead for 
Did you mean: 
Post Patron
Post Patron

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

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!