Forum Discussion
Community ChampionKill an In Progress Refresh
Hi rsbin
No worries, you could try this below.
You would need to have system administrator access
Terminate (kill) a specific session on a server - Azure SQL Data Dictionary Queries (dataedo.com)
Super UserHI rsbin
What I have done in the past is to re-upload the PBIX file and this often forces the current refresh to be stopped because the newer file will overwrite the existing dataset.
- rsbin
Appreciate the response. I have tried re-publishing repeatedly in the same workspace. It just seems to hang. Publishing to a different workspace does work, but I need to keep it in this workspace.
I am very tempted to delete the file and dataset from the current workspace - but this is a last resort. If I can't republish to the same workspace, then I run into all sorts of additional problems (I am embedding this into a web page).
I will try it again...whilst writing this message...and perhaps more patience will pay off.
Again, thanks for taking the time...and if you have any other ideas....please pass them along.
Regards,
- GilbertQ
Hi rsbin
Could you not kill the connection on your cloud source?
For example if it is Azure SQL you can kill the SPID?- rsbin
We have recently lost our Database Administrator, so am not well versed in the techy stuff.
I am working with an Azure SQL table. If you can give me some further instructions on this "SPID" thing, I am pretty good at following directions.
Appreciate any further details.
