Forum Discussion
Power BI (On Prem) memory leak?
I have two Power BI reports using direct query. Both of these reports get called once every minute by a .net page I wrote that is basically just a wrapper around the report that tells the screen to refresh every 60 sec. After about a weeks time of this dashboard being up, the Power BI Server seems to grind to a halt, at which point I reboot the server, and then everything is good for another week. I just checked the report rendering time in the browser 24 hours after having bounced the PowerBI Server and already the report is taking 13 seconds to refresh vs about 1 sec after a reboot....so I rebooted the server again, and we're back to 1 sec refresh times. There's literally nothing else on that PowerBI Server, and at the moment these are the only 2 reports that have been created. Anyone else having similiar issues like this?
3 Replies
The CPU was at around 40% and the mem usage was around 1.2 gig. So it's not like the server itself was crippled or anything. The server seemed to be fine when RDP'ing into it.
I'll spin something up here to see if I can replicate this if you can share your web app code. I have seen some issues in the captive SSAS instance that's behind the SSRS Service slowing down, or at least not responding quite as quickly over time.
It might be easier to identify if instead of restarting the server you bounced specific services to see if you can isolate it down to a specific service.
We restart the SSRS-PBI service overnight every night currently.
