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

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

Anonymous — Thu, 16 May 2019 20:43:12 GMT

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 : "Exception of type 'System.OutofMemoryException' was thrown.

Within the Report builder, I create a Data Set and use the connection string listed in the "Server Settings" location for that Data Set in the Web Power BI (Premium). I then select all of fields I need from that Data Set to query and finish completing the data set. I can run the report with 3 fields selected. However, when I attempt to run a report with more than 3 (17 total) I receive this error. I am not sure why I would be getting a 'System.OutofMemoryException' when I am connecting to a dataset and not an actual database?

Any thoughts? Are there certain settings that would have to be configured in the PowerBI Workspace where the Data Set sits?

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

ITGeek555 — Thu, 16 May 2019 22:41:45 GMT

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

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.
Another approach would be to upload the full report (all 17 fields) to PBIRS and see how the 64 bit reporting services engine behaves.

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

Anonymous — Tue, 09 Jul 2019 23:37:55 GMT

I'm having the exact same issue and would really appreciate a solution...

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

bradsy — Wed, 10 Jul 2019 23:00:49 GMT

If either of you can send me a generic repro or describe exactly what to do, we will take a look and see if it is an issue we can fix. bradsy@removethistextmicrosoft.com

The one thing Report Builder does not do is throttle the query. If you are pulling from a data source that has a lot of data to design a report, I would suggest you add a top xxxx on your query. When it comes time to publish, remove the top xxxx

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

Anonymous — Thu, 11 Jul 2019 14:10:35 GMT

Thanks bradsy, I emailed you.

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

Anonymous — Fri, 17 Jan 2020 23:28:43 GMT

bradsy I am getting this same error when using Power BI Report Builder or Visual Studio to connect to a Power BI Premium Dataset.

If I have less than 3 fields, the report will render but otherwise it gives the out of memory error in both Power BI Report Builder and Visual Studio. I tested with Power BI Report Builder on 2 PCs and received the same error on both.

The actual query returns relatively quickly in the query designer and is not a lot of data.

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

paulboolos — Wed, 06 May 2020 12:06:49 GMT

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,

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

bradsy — Wed, 06 May 2020 16:22:24 GMT

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.