Forum Discussion

viera00's avatar
viera00
Helper II
9 years ago

Help - Memory Problem with Published Reports - Small amount of data

Hello Everyone,   I'm having a strage problem.   I've created a data model in PowerBI Desktop, with aprox ~30 tables. This tables have an average of 15 columnas. The tables have little data. Only...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

GV,

I had a similar 'memory leak' problem recently, though with a table rather than a matrix and only on PBI Desktop, not even pusblished to PBI Service.  When I added a column to the table, RAM usage just kept increasing for the Microsoft SQL Server Analysis Services (msmdsrv.exe) until it ran out of memory.  The solution was simply to delete and re-create the table visual on the report.  Worth a try?

 

Cheers,
SW

  • viera00's avatar
    viera00
    Helper II
    9 years ago

    Hello Steve,

     

    Thank you very much for your reply.

     

    Unfortunatelly recreating the matrix (or table, the problem happens with both) does not fixes the issue.

     

    Just to clarify, the problem is not happening in PowerBI Desktop. I see that is consumes a lot of memory, but does not crash.  

     

    In PowerBI Service, I recevie the error, but if I filter through one of the slicers, the table works. 

     

    My thoughts are that Microsoft is not dedicating more than 2GB of memory for my user.

     

    I would appreciate if anyone had this kind of issue, or at least somthing similar like steve, please send a tip, as I'm not being able to solve it.

     

    Thanks again Steve.

     

    Regards,

     

    GV