cancel
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].
Cluster URI:WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID:992f4230-f33a-4fff-b8ad-0e6363d425bb
Request ID:92033a34-2abf-47e2-9d33-f4330e2620c6
Time:2019-04-03 11:09:11Z
Status: Delivered
Comments
Moderator

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 

Regular Visitor

Hi,

 

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.

 

Regards,

Grrrrrrrr

 

Anonymous
Not applicable

Hi

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.

Moderator

Hi @Anonymous, 

 

Please create a support ticket to get dedicated support. 

 

Support Ticket.gif

 

Best Regards,
Qiuyun Yu 

Moderator
Status changed to: Delivered