Skip to main content

Power BI

New

Premium Capacity - Live monitoring of running queries + kill a blocking query

Vote (6) Share
Marc-Andre Turmel's profile image

Marc-Andre Turmel on 04 Mar 2022 14:03:03

In Premium Capacity administration, it would be useful to be able to watch and kill running queries if they are too long and blocking a lot of other queries. This would be useful when accidentally some user start a query that is too large for the capacity level and becomes a head blocker for all other operations in the Power BI service unless that user closes its operation. But sometimes the user doesn't know or realize he is blocking everybody else.


Something similar in concepts to what a SQL admin would do using sp_who2 and kill commands would be nice for capacity admins.