Data mart non stop refresh

[Sim_9]

i can't seem to find a way to stop my data mart from refreshing, it usually takes around 5 minutes and now it's been refreshing for 20 hours.
Don't know what to do ??

[Sim_9]

it did eventually stop after running for 19hours, but can't refresh it or do any transformation cause i'm getting this error message.
ErrorMessageResponse status code does not indicate success: 403 (Forbidden).

[collinq]

Hey @Sim_9 ,

Are you in Premium?  If so, this shows where the stop button is:  Dataset refresh cancellation is now available in Power BI Premium | Microsoft Power BI Blog | Micros...

I also read one thread that talked about stopping/restarting your gateway server.  That is a pretty huge sledgehammer but it would do the trick I guess.

[fvalento2023]

I'm in the same situation.

How did you get the 403 (Forbidden) to go away?

[collinq]

Hey @Sim_9 ,

If you go to the Datamart, you can open the Dataset that you want to stop the refresh by clicking on the elipses and then select the "Schedule Refresh" and select "Cancel Refresh" there.

[Sim_9]

I want to stop the refresh of the datamart not the dataset
We are able to stop the refresh for datasets and data flow but not for datamarts
i was wondering if there was another way to go around it cause it is constantly refreshing and because of that i'm not able to do any transformation neither delete it.