- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

Helpful resources
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.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

User | Count |
---|---|
57 | |
30 | |
24 | |
23 | |
20 |
User | Count |
---|---|
57 | |
37 | |
23 | |
22 | |
20 |