Limit the duration of DAX queries (timeout)

[Anonymous]

I have a few users sometimes executing highly imperformant DAX queries against an OnPrem SSAS Tabular database.

Is there a server side setting to limit the duration of queries so that the server cancels long running queries automatically?

[dm-p]

Hi @Anonymous,

I've done this in the past but I don't have access to an SSAS tabular instance at the moment to confirm.

You should be able to modify the server properties, specifically the ExternalCommandTimeout property, which is currently set at 3600 seconds (1h) by default.

You'll likely need to restart the instance for settings to take effect for end-users, so you might need to schedule an outage window to apply the config.

I hope you find this useful. Good luck!

Daniel

---

If my post helps, then please consider accepting as a solution to help other forum members find the answer more quickly 🙂