Datamart Scheduled Refresh - Data Load Error

[pione3r]

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 your datamart." error. Yet I can see new data in ETL mode.

I have checked the SQL server, no changes there since the initial connection.

I then setup Increcemental refresh to get more details, below image was the error message "Local SQL execution failed".

To confirm the error is not related to the SQL source, I recreated the datamart. The scheduled refresh been running fine without issues. My worry is if I move to this datamart, this data load error could happen again.

Any help would be appreciated.

[Anonymous]

Hi @pione3r 

When you create a new datamart and set scheduled refresh , the refresh can run successfully , did you set incremental refresh for the datamart ?

Best Regards,
Community Support Team _ Ailsa Tao

[pione3r]

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

[pione3r]

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.