I have setup four datasets with schedueled refreshes (each once a day on different times). The first few days they all work well and all of a sudden they fail without any reason:
Manual refreshes in the power BI portal succeed (sometimes also the schedueld refresh the next day) but then the refreshes fail again
I had a MS consultant looking at it but his advices (recreate the DB connection and reconfigure the refreshes) did not resolve the problems on a long term.
Here also some of the most important information about the circumstances:
Is the problem only with one data source?
No, besides the 3 error messages for datasets based on this Azure SQL DB, the same error message occurred in parallel for a data source based on Applications Insights.
Has the problem occurred several days in a row or by chance?
The first time and also now the initial error message occurs randomly. The error repeats itself with every refresh until the Scheduled Refresh is disabled by the system. When I reactivate it, it works for some days (a week?) and then fails again.
Does the problem always occur on certain days?
As mentioned above, on each refresh, once the error occurred.
If you then restart the refresh manually, does it work?
The manual refresh works and sometimes the scheduled refresh works the next day, but then it fails again.
Here you can see the history of one dataset:
I restarted the Scheduled Refreshs for all 4 datasets on 29.11. One refresh ran twice a day and all others only once. All 4 datasets started to throw error messages on the 4.12.