Schedule refresh fails with excel sheets sharepoint online

[Anonymous]

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

[v-qiuyu-msft]

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 

[Anonymous]

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]

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.

[v-qiuyu-msft]

Hi @Anonymous, 

Please create a support ticket to get dedicated support. 

Best Regards,
Qiuyun Yu