Forum Discussion

RG01's avatar
RG01
New Member
1 year ago
Solved

Query Memory Limit (%) bypassed

Hello,   I hope you are doing well.   Let me begin by giving you the context of my client :  - P1 Premium Capacity - Query Memory Limit (%) set at 10 % I have a semantic model B which is plugg...
  • jaineshp's avatar
    1 year ago

    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