Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Continued Contributor
Continued Contributor

How to Use "Query Memory Limit (%)" in Premium Capacity?

"Query Memory Limit (%)" is a setting on a Premium Capacity. 


This page describes it as "The maximum percentage of available memory that can be used for temporary results in a query or DAX measure." And this page says, "Some queries/calculations can result in intermediate results that use a lot of memory on the capacity. This can cause other queries to execute very slowly, cause eviction of other datasets from the capacity, and lead to out of memory errors for other users of the capacity. Without this setting, capacity administrators would find it challenging to identify which report/query is causing the problem, so that they could work with the report author to improve the performance. With this new setting, admins can better control impact of bad or expensive report on others using the capacity."


We do have some memory-intensive reports, and our capacity can be over-used. I think this setting might be useful, but I cannot find any more information about it.


First of all, it defaults to '0' ... and I am wondering what '0' means. Does this mean no limit is applied to any given query?


And then, I am wondering what the community has discovered is a reasonable range of values to use. I feel like maybe 5 or 10 percent? I feel like a single query should not take up too much resources! But then I don't want to set an overly-restrictive limit.

Continued Contributor
Continued Contributor

Oops, I just fixed a typo in my original post.


Another critical question about this which should be made clear, please, if anyone can answer it: is this a per-query limit, or is this a cap on the combined memory consumed by all queries?


E.g., say I have set "Query Memory Limit (%)" to 30. Then, say we have multiple simultaneous queries/DAX measures in reports being rendered. At a given time, is the combined total memory consumed for all temporary results of all the queries/DAX measures 30%? Or, is each query limited to consuming a max of 30% of memory?

Continued Contributor
Continued Contributor

Thanks, @v-shex-msft ...


Our capacity does have one very large dataset with some complex reports/queries; plus several other medium/small-sized datasets. Capacity over-utilization is an issue.


Does anyone have any real-life experience using this setting? What values did you test and ultimately use?

Community Support
Community Support

Hi @kevhav,

#1, I also check these premium documents but not found clearly describe this feature. I guess '0' should mean 'no limit' or use the 'default' limit amount.

#2, It should be related to your capacity usage(high resource usage and low resource usage) :

1. If only one dataset assigns in premium capacity, you do not need to configure this parameter.

2. If they are high resource usage by other datasets, you can consider configuring a small number to release the resource which used by query operations/calculations.

3. If your tenant does not contain datasets that spend large amounts of memory resources, you can increase the parameter amount to increase query processing speed. (If your dataset not very large, you can set parameters from 25% to 50%. If they are too many records stored in your dataset, you can consider configure it less than 45% to reduce the performance effects with other datasets)


Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors