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
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

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

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks bradsy, I emailed you.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.