Reply
Dhinesh
Frequent Visitor

Memory issue in report builder while running a query

Hi,

 

I am trying to create a paginated report in report builder using power BI dataset as a source. After I added required columns in table visual and run a report in report builder, it shows below error.

 

Resource Governing: This query uses more memory than the configured limit. The query — or calculations referenced by it — might be too memory-intensive to run. Either simplify the query or its calculations, or if using Power BI Premium, you may reach out to your capacity administrator to see if they can increase the per-query memory limit. More details: consumed memory 10240 MB, memory limit 10240 MB. See https://go.microsoft.com/fwlink/?linkid=2159752 to learn more.

 

Then I tried with power BI Desktop, added many columns in a tabular visuals, it works fine. It didn't work in report builder.

 

It will be helpful if anyone share any thoughts.

 

Thanks in advance.

 

1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community Support

Hi, @Dhinesh 

 

The fact that it works in Power BI Desktop does not guarantee the same performance in Report Builder. Paginated reports can be more memory-intensive, especially when dealing with large datasets or complex aggregations. Ensure that your report is designed efficiently for paginated reporting.

 

Step 1: Review and simplify the query or calculations used in the report.

Optimization guide for Power BI - Power BI | Microsoft Learn

Step 2: Contact your Power BI Premium capacity administrator to discuss increasing the memory limit if applicable. 

Manage Microsoft Power BI Premium capacities - Power BI | Microsoft Learn
Step 3: Optimize the report by removing unnecessary elements and using filters.

Step 4: If the issue persists, consider breaking the report into smaller, more manageable parts.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-zhangti
Community Support
Community Support

Hi, @Dhinesh 

 

The fact that it works in Power BI Desktop does not guarantee the same performance in Report Builder. Paginated reports can be more memory-intensive, especially when dealing with large datasets or complex aggregations. Ensure that your report is designed efficiently for paginated reporting.

 

Step 1: Review and simplify the query or calculations used in the report.

Optimization guide for Power BI - Power BI | Microsoft Learn

Step 2: Contact your Power BI Premium capacity administrator to discuss increasing the memory limit if applicable. 

Manage Microsoft Power BI Premium capacities - Power BI | Microsoft Learn
Step 3: Optimize the report by removing unnecessary elements and using filters.

Step 4: If the issue persists, consider breaking the report into smaller, more manageable parts.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

avatar user

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)