Datamart Refreshing Stuck

[josecgomez]

I have a DataMart I have been using quiet heavily but it is stuck refreshing has been in that process for hours. Is there a way to cancel or stop the refresh?

[amitjadhav3]

I had same issue as I was not able to cancel Datamart refresh stuck for almost 8 hours. I had workspace in Premium capacity. To resolve this issue I had to remove workspace from Premium capacity and add it again to Premium capacity. Due this you will get capacity Migration in progress error in refresh and it will fail but refresh will get failed and cancelled and you can work on datamart then.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[cst_bi]

Cool..

[v-yangliu-msft · Accepted solution]

Hi  @josecgomez ,

Datamart is still a preview feature, more information needs to be improved, if you are using a Data Gateway, one way to cancel refresh would be restarting the Gateway on the VM. That will cancel the refresh. However, if you are only using cloud sources, I'm afraid there is no "Cancel Datamart" action on Service yet. 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.