Anonymous's avatar
Anonymous
Not applicable
7 years ago
Status:
Done

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
Reports

5 Comments

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
    Anonymous
    Not applicable
    7 years ago

    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.

Completed Ideas