How can we improve Power BI?

Cancel Option when "Working On It"

Please provide a cancel button/option when a DAX calculated column is processing.

There are times when I create a calculated column, and the logic causes extremely long wait times for the column to evaluate on the table. My only option is to kill the background SSAS process or PBI Desktop, and reopen the report.

My tables are about 1-6 million rows.

113 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jonathan Homiak shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    5 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Paul O'Connor commented  ·   ·  Flag as inappropriate

        This is an absolute must have that really should have been there firstly.

        Microsoft, if you push products, inevitably people will try and play with them. If they keep getting stuck as i do where i have to pray for the working on it to time out, it isnt going to be a worthwhile product.

        People try different codes to do different things, so if there is no option to cancel the running query etc., loss of work and frustrations is all that will be achieved.

        I am currently sitting here waiting for one so i dont lose work that has taken some working out to get done.

        A real frustration to have to lose work due to the lack of a simple ability to cancel what you are doing.

      • john ridge commented  ·   ·  Flag as inappropriate

        Additionally, it would seem very very useful to have
        - a more general "stop all automatic calculations" option
        - an ad-hoc "compute now" buttom
        to allow a user to enter the DAX for multuiple new computed measures / columns etc.

        The user coud then either signal to the system either :
        a) press the "compute now" button
        OR
        b) change the general setting back to "automatically compute"
        etc

      • Anonymous commented  ·   ·  Flag as inappropriate

        Alternatively when you know you have made a mistake on a measure, however need to wait to make the edit

      Feedback and Knowledge Base

      Ready to get started?

      Try new features of Power BI today by signing up and learn more about our powerful suite of apps.