Showing results for 
Search instead for 
Did you mean: 
Karin New Member
New Member

Possible to cancel queries in Power BI Service?

As we have found out, when the user runs a PBI report connected to SSAS and gradually clicks on different slicers or tabs of the report, new queries are continuously launched, without cancelling the previously started ones. A user can select slicers asynchronously without waiting for previous actions/queries to be completed, and continously start new and new queries. When new slicers are selected, this should cancel the previously started queries (because parameters have meanwhile changed and they are no more relevant), however they continue running. Even one user can easily "kill" the server by such clicking on slicers and tabs, not even talking about tens or even hundreds of users.


After a while, this leads to an enormous amount of queries running at the same time, consuming a lot of server resources and effectively blocking the server to process new queries. This becomes a huge problem especially when more users are running PBI reports at the same time.

Any recommendations to solve this problem?


Thank you very much for your help and support!

sdjensen Senior Member
Senior Member

Re: Possible to cancel queries in Power BI Service?

I don't think you have any options to cancel a running query. You should create a feature request (Idea) to get this. I am sure this will be supported by many.

ankitpatira Super Contributor
Super Contributor

Re: Possible to cancel queries in Power BI Service?

@Karin Not the best possible answer but one way would be to limit the number of slicers on report. Also make sure slicers have require single select on so that only one value is selected at a time. The way power bi works as you've described in your post that it sends queries for each user action is by design so I doubt if that can be changed. Also set a default slicer for your report and so user would only change it if it's really required.
You should be able to get more details from internal working of product
sdjensen Senior Member
Senior Member

Re: Possible to cancel queries in Power BI Service?

Did you read this article from the documentation regarding direct connections to SSAS?


I am spooked about the last bit:

If you pin visuals from a report to the dashboard, the pinned tiles are automatically 
refreshed every 10 minutes. If the data in your on-premises Analysis Services server is
updated, the tiles will get auto-updated after 10 minutes.


I wonder if this means that if you create a dashboard with tiles based on data from you SSAS cube this will make the power bi servers to automatically send a query every 10 minutes per tile - this could also create a lot of queries, so watch out for dashboards.

jreed Frequent Visitor
Frequent Visitor

Re: Possible to cancel queries in Power BI Service?

We are new to O365, Power BI and all it holds, good and bad - it is my hope that this issue has been long ago resolved and not simply tabled into the sunset.  We currently have lesss than 10 users , less than  a dozen reports each. We have already seen this issue...not a suprise that MS doesn't have a list of "gotchas" - does anyone know of a fix ( besides bouncing the gateway)?

Helpful resources

New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)