Skip to main content

Power BI

New

New capacity setting: “Query CPU limit in %”

Vote (27) Share
Jan F's profile image

Jan F on 17 Aug 2023 09:44:48

The Premium capacity settings allow to limit queries in terms of memory usage and execution time (timeout). However, there is no such setting to limit CPU footprint for individual queries.

Therefore, a single poorly designed query can eat up all available CPU and cause throttling for an entire capacity. A new “Query CPU limit in %” setting could help reducing noisy neighbor effects caused by overly expensive queries.