Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Aborting a running query in Snowflake via Power BI

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> ?

Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, Anonymous 

     

    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

3 Replies

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, Anonymous 

     

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      v-janeyg-msft
      Icon for Community Support rankCommunity Support
      5 years ago

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

       

      Best Regards,

      Community Support Team _ Janey