Forum Discussion
stop running query
- 1 year ago
It is not possible to stop a running query in Power BI from the user's side.
Once a query is triggered – whether by changing a filter, opening a page, or any other action – it is sent to the engine for execution and cannot be canceled midway.
Power BI does not offer a "Stop" button for queries like you would find in development tools such as SSMS (SQL Server Management Studio).The only options available for the user are:
-
If using Power BI Desktop – close the file or the application.
-
If using Power BI Service – refresh the browser tab or close it.
It’s important to understand that these actions do not actually stop the query running on the server; they only disconnect the session from the user's side.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
-
Hi powerbiexpert22 ,
Thank you for reaching out to the Microsoft Fabric Community. Also thank you Ritaf1983 and Akash_Varuna for your input.
Currently, Power BI does not allow users to manually stop or cancel a running query once it has been triggered. Whether it is initiated by a slicer change, page navigation, or a visual refresh, the query will run until completion, and there is no "Stop" or "Cancel" option available to users as seen in tools like SSMS.
In Power BI Desktop, users can close the application or file to disconnect, and in Power BI Service, refreshing or closing the browser tab will sever the front-end session, although the backend execution may continue.
Additionally, for environments using Premium or Fabric capacities, administrators can monitor and manage queries using tools like the Capacity Metrics app or Admin APIs, but this capability is not available at the user level.
I hope this will resolve your issue, if you need any further assistance, feel free to reach out.
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thankyou.
- Anonymous1 year agoNot applicable
Hi powerbiexpert22 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.