Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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.
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.