Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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 🙂
Proud to be a Super User!
My course: Introduction to Developing Power BI Visuals
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |