Forum Discussion
Query memory limit for XMLA operations
Hello kamilnoczynski ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution we provided for your issue worked for you or let us know if you need any further assistance?
Your feedback is important to us, Looking forward to your response.
Thank You.
The main issue is that users of Excel connected to the semantic model are consuming a lot of Premium Capacity and we see high peaks in fabric capacity metrics, and there is a need to set a limit for them. Would it be a better idea to change the settings in SSAS at the workspace level as described in this article: https://powerbi.microsoft.com/en-us/blog/analysis-services-server-properties-in-power-bi-premium-are-now-in-public-preview/ ?
Unfortunately it is not possible to do any changes in semantic model
Hi kamilnoczynski ,
Since modifying the semantic model is not feasible, the optimal approach is to manage query memory usage at the workspace level within the Power BI Premium capacity settings.
To prevent Excel users from consuming excessive memory, you can adjust the Query Memory Limit (%) in the Power BI Admin Portal.
While you can’t increase the query memory limit over the published thresholds, capacity admins can reduce the query memory limit in the admin portal by setting the Query Memory Limit % property on the capacity.
The default value of this property is 0, which means the maximum value for the capacity SKU you’re using will be applied; any other value will be interpreted as a percentage of that maximum value
Steps to Apply :
1. Open Power BI Admin Portal and go to Capacity Settings.
2️. Select your Premium Capacity.
3️. Expand Workloads and find Semantic Models.
4️. Set Query Memory Limit (%):
- 0% (Default) → Uses the max memory allowed.
- Lower value (e.g., 50%) → Limits memory per query.
5. Click Save to apply changes.
Helpful References: Understand your Fabric capacity throttling - Microsoft Fabric | Microsoft Learn
If my response solved your query, please mark it as the Accepted solution to help others find it easily.
And if my answer was helpful, I'd really appreciate a 'Kudos'.