Forum Discussion

dbeavon3's avatar
dbeavon3
Memorable Member
2 years ago

Calculated Table. Never Finishes. Working on it.

I've noticed that getting data into a model via a calculated table (DQ for PBI dataset) is very problematic.   I plugged in my rough-draft DAX calculation, iterated until I was satisfied, then remo...
Need Help
dbeavon3's avatar
dbeavon3
Memorable Member
2 years ago

Another thing that often crashes the calculated table is the fact that PBI can't seem to load more than one million rows from a PBI dataset hosted in the service.

Aside from the various things that cause the calculation to crash, there is no way to cancel the calculation from the user side.  I really think this calculation engine needs to have a cancel button.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi   dbeavon3 

    Thank you for your valuable suggestion on Power BI calculate table, if it is important to you, you can propose an idea about this, you can submit your idea by going to the link below:
    Home (microsoft.com)

     

     

     

     

    Best Regards,

    Jayleny

     

    If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.

     

    • dbeavon3's avatar
      dbeavon3
      Memorable Member
      2 years ago

      For lack of a cancel button, how do people cancel the calculated table operation?

      Do you kill something like msmdsrv?  Or do you interrupt the remote network connection?