Forum Discussion
Memory issue in report builder while running a query
Hi, Anonymous
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.
Community SupportHi, Anonymous
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.