Showing results for 
Search instead for 
Did you mean: 

Schedule refresh fails with excel sheets sharepoint online

I have multiple reports running in PBI accessing Excel sheets located in SP Online.

They seem to fail pretty consistently during the day with the following error.

The table name changes from error to error.

When they do not fail at night it only takes a few minuttes to load.

Any idea to what is going on or to fix it? Thanks


Last refresh failed: Wed Apr 03 2019 13:09:11 GMT+0200 (Romance Daylight Time)
There was an error when processing the data in the dataset.
Hide details

Message:SharePoint: Request failed: Unable to connect to the remote server Table: [XXX].
Activity ID:992f4230-f33a-4fff-b8ad-0e6363d425bb
Request ID:92033a34-2abf-47e2-9d33-f4330e2620c6
Time:2019-04-03 11:09:11Z
Status: Delivered
Community Support

Hi @Anonymous, 


Please test again, check if the same issue still occurs. 

Also you can download the report and open it in Power BI desktop and refresh data to see if it's can be completed successfully. 


Best Regards,
Qiuyun Yu 

Not applicable



have you setting up same schedule refresh timing for all you're report's.

Example, two or more reports are refreshing everyday at 2:00PM.


if yes,

make sure to set up different schedule refresh timing for reports.





Not applicable


If I open the reports in desktop the refresh works fine. 

My reports are set to refresh at different times, so thats not the problem.

Community Support

Hi @Anonymous, 


Please create a support ticket to get dedicated support. 


Support Ticket.gif


Best Regards,
Qiuyun Yu 

Community Support
Status changed to: Delivered