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...
Turns out there was corrupt data in one of the fact table which didn't match with the underlying schema of Datamart. But Datamart data load failed to identify and explain this error. Issue with Datamart is it doesn't narrow down the problem.