Aborting a running query in Snowflake via Power BI

[aztangirov]

When a reporting query runs in backend (Snowflake), is there a possibility to cancel that query from web version of Power BI? For example, a user selects a wrong table or it takes a long time for the report to run.
Absence of such a feature wastes resources from Snowflake side since the query is still running in backend, although the user does not need the results anymore.

We tried it with simply closing the reporting window in Power BI, but the corresponding query still runs in Snowflake until the full execution finishes.

In general, if there is no such a feature, would it be possible (as a developer) to adjust the Snowflake - Power BI connector to fire a query cancellation function - SYSTEM$CANCEL_QUERY<query_id> ?

[aztangirov]

Hi Janey,

thanks for the reply. I submitted the idea in the link you provided.

Can the feature be added only from Microsoft's side or we can still adjust the Snowflake - Power BI connector ourselves to develop such a custom feature?

Basically, it should get the query id and pass the cancel query command to Snowflake:

SYSTEM$CANCEL_QUERY<query_id>

[v-janeyg-msft]

@aztangirov  I think it's hard for you to develop it yourself, so do I.

Best Regards,

Community Support Team _ Janey

[v-janeyg-msft · Accepted solution]

Hi, @aztangirov 

AFAIK, It seems that there is no such cancel feature, if you don’t want to view the data in real time, you can use the import mode. It only sends the query when refreshed.

You can also sumbit your idea here. Hope it will appear soon.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,

Community Support Team _ Janey