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
ITGeek555's avatar
ITGeek555
Helper II
7 years ago

Given the fact that this is the Power BI Report Server (PBIRS) forum I will assume you plan to push the report to PBIRS.

  1. I have had the same issue with Report Builder.  It is a 32 bit application and therefore is limited to the VAS memory space (limit 2GB).  If your workstation has a lot of applications open then it is possible for Report Builder to run out of addressable RAM.  Restart you workstation and only run Report Builder to see if the issue re-occurs.
  2. Another approach would be to upload the full report (all 17 fields) to PBIRS and see how the 64 bit reporting services engine behaves.
  • 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
      Microsoft 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.