The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi, I'm trying to create a paginated report in Report Builder.
I haven't been able to get it to let me view the report, not even if I try to run it with less data.
The data source is quite large, is there maybe something I can add in the query to make it run?
Solved! Go to Solution.
Hi @nataliafedoun ,
As per my understanding, the System.OutOfMemoryException error is an error that is raised by Reporting Services when an operation requests more memory from the system and the system cannot provide the memory. This issue always occur when the computer does not have sufficient memory to complete the requested operation. Including the report is too large- returns too much data by the dataset.
In order to narrow this issue, you could refer to the following methods:
Besides, you could also refer to the following document: System.OutOfMemoryException(Microsoft SQL Server Report Builder 3.0 Product version 11.0.3000.0) | M...
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @nataliafedoun ,
As per my understanding, the System.OutOfMemoryException error is an error that is raised by Reporting Services when an operation requests more memory from the system and the system cannot provide the memory. This issue always occur when the computer does not have sufficient memory to complete the requested operation. Including the report is too large- returns too much data by the dataset.
In order to narrow this issue, you could refer to the following methods:
Besides, you could also refer to the following document: System.OutOfMemoryException(Microsoft SQL Server Report Builder 3.0 Product version 11.0.3000.0) | M...
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.