Get Error in Service

Hi Anonymous 

The error you're encountering in Power BI Service — "Resource Governing: This query uses more memory than the configured limit" — indicates that the visual or its underlying DAX query is exceeding the per-query memory limit allowed by your current license tier, which is Power BI Pro. In Pro, the memory and CPU resources allocated for dataset processing and visual rendering are more constrained compared to Power BI Premium. Despite your efforts to simplify the DAX for the visual, it's likely that the combination of data volume, relationships, calculated columns/measures, or visuals themselves still leads to high memory usage (in your case, 1,331 MB, which hits the exact memory ceiling for a Pro environment).

This issue typically doesn’t occur in Power BI Desktop because the desktop version uses your local machine’s resources without the same memory throttling. But once published to the Power BI Service, queries are governed based on your tenant’s capacity tier.

To resolve this:

1. Simplify the visual: Reduce the number of fields, complex measures, or visual filters.

2. Avoid complex calculated columns/measures especially ones using iterators like

   SUMX, FILTER, or nested IF conditions.

3. Reduce data granularity: Use aggregations or summarized tables instead of detailed data.

4. Optimize the model: Remove unnecessary columns, relationships, or hidden fields that increase model size and complexity.

Since you are on Pro, and not Premium, you cannot increase the memory limits. If the report must run in its current state, consider moving the workspace to a Power BI Premium capacity (P SKU or F SKU in Fabric), where the per-query memory limit is higher and adjustable by an admin.

For now, use tools like Performance Analyzer in Power BI Desktop and DAX Studio to find the most expensive queries/measures, and reduce their memory footprint.