I created a datamart directly connected to a single source Azure SQL database. The scheduled refresh has been running fine for a month until recently. I keep getting "There was a problem refreshing y...
Hi Ailsa,
In the newly created test datamart, I tested both the Scheduled Refresh as well as Incremental Refresh and both worked perfectly fine.
The existing primary datamart, with exactly the same source and settings has suddenly failed Scheduled Refresh. I then switched off the Scheduled Refresh, and setup Incremental Refresh but that too failed with the error message as in the image.
I am trying to understand why primary datamart has sudden connection problem.
Thanks