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.
Hi kamilnoczynski ,
Thank you Akash_Varuna , for your quick response. The Query Memory Limit % and Query Timeout settings in Microsoft Fabric are essential for queries executed via the XMLA endpoint, including those from Excel connected to a Semantic Model. To enhance performance and prevent query failures.
1. Adjust the Query Timeout setting in Power BI Service to permit longer execution times and avoid timeouts.
2. Increase the Query Memory Limit % to allocate more memory resources and prevent failures due to memory constraints.
3. Optimize DAX measures in the Semantic Model to improve query performance.
Implementing these adjustments will optimize query execution and enhance performance when utilizing the XMLA endpoint.
Helpful References :
Configure Workloads in Power BI Premium
Semantic Model Connectivity with XMLA Endpoint
Let me know if you need further refinements.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.