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
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
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.
make sure to set up different schedule refresh timing for reports.
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.
Please create a support ticket to get dedicated support.