Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power BI Paginated Report Builder Dataset run error -- 'System.OutofMemoryException'

Good Afternoon,   I was wondering if someone could help me troubleshoot an error I am receieving when attempting to run and create a paginated report in PowerBI Report Builder..   The error is : ...
power bi
POWER BI Reports in web application
report builder
paulboolos's avatar
paulboolos
Regular Visitor
6 years ago

Same issue happening with me; seems Report Builder gives the out of memoery when it reaches 1200MB of memory use.
If I filter my data to a smaller set, the report runs fine.
Is there a 64 bit version of Report Builder?

 

Updating this post with some new findings; I noticed that if I decrease the number of parameters on the report from 8 to 2, I am able to bring in more data before I get the out of memory issue. So with 8 parameters it couldn't return 175k rows, but with 2 parameters it returned a little over 175k rows. These parameters are simple == nothing complicated.

Thank you,

bradsy's avatar
bradsy
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Hi paulboolos,

 

There is no plan for a 64 bit version at this time. The processing of data is fairly memory intensive. If you can off load some of the processing to the data source, like pre-aggregating data, that would help.