Forum Discussion
Query Memory Limit (%) bypassed
Hey RG01,
A few things to check/consider:
Query Memory Limit applies only at dataset level (semantic model A), but when chaining models (B connected to A), some queries can be pushed down differently and not fully respect the limit.
Composite/Chained models often generate more complex queries, which may bypass the set threshold.
To control it, review the report design (limit unrestricted visuals, avoid high cardinality fields).
Apply row-level filters or perspectives to reduce query size for end users.
Monitor with Capacity Metrics App to track which queries are spiking usage.
If critical, consider Dedicated capacity workload settings or limit user access to building unrestricted Live visuals.
Fixed? ✓ Mark it • Share it • Help others!
Best Regards,
Jainesh Poojara | Power BI Developer
Super UserHi RG01
From my understanding of query limit, this only applies to semantic models where the data has been imported. So all the querying is actually happening within the semantic model, which will then rely on the query limit to apply. When you're using direct query, this is not actually querying in the semantic model, but rather in the direct query data source, and that is why it is by passing the query limit. But unfortunately you will still be using capacity. For the usage of the reports.