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.
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
New Advanced Editor hides query name and locks editor window
Classic Power Query 'Advanced editor' opens as a separate movable, resizable window with the query name as its title. One could drag and keep the main editor visible : queries pane, applied steps, d...Mardurolla5 hours agoRegular VisitorNew8Views0likes0CommentsGet Secret from Azure Key Vault using Fabric Workspace Identity
Users can access key vault secrets using notebookutils.credentials.getSecret. This is based purely on the user's access (or object owner's access, if the notebook is being run in a pipeline). In larg...sean_cochran5 hours agoResolver INew3.1KViews14likes3CommentsNew Power Query experience: Advanced Editor modal hides query name, and locks the editor
In the classic Power Query editor, the Advanced Editor opens as a separate, movable, resizable window titled “Advanced Editor – QueryName”. I routinely drag it to a second monitor and keep the main e...lamogiro6 hours agoNew MemberNew7Views0likes0CommentsPaginated Reports with PowerQuery - Cloud connections for Snowflake connector
Current situation: Power BI report builder used to build a report using Power Query dataset. Report builder picked the right cloud snowflake DB connection (created in Power BI service portal - app...jarjis_nbcu6 hours agoNew MemberNew2Views0likes0CommentsNew Power Query experience: Advanced Editor modal hides query name, and locks the editor
In the classic Power Query editor, the Advanced Editor opens as a separate, movable, resizable window titled “Advanced Editor – QueryName”. I routinely drag it to a second monitor and keep the main e...Mardurolla6 hours agoRegular VisitorNew8Views0likes0Comments