Forum Discussion
Power BI Report Server Extremely Slow
Hi. Thank you for your response, and apologies for the delayed response. The site is experiencing slowness with all pre-existing dashboards, not just the one I'm working on, and it's been a sporadic issue over the past year. Still, I'll check out your suggestions.
-E
We recently found our server slowing down considerably. Once the PBI reports were up they seemed to be pretty fine. We eventually tracked it down to the AntiVirus running on the Server. This was causing a lot of latency in spinning up the captive SSAS instance and data sets in the background as reports were running. We excluded the PBI Report Server install directory from the AV active scanning. It certainly helped though the network scanning stuff still seems to be giving us some delays/issues.
ITGeek555Helper II
I would also look into the resourcing on the server hosting PBIRS. Noting that the reports are 'rehydrated' from the database into local SSAS instances on the server, if there is insufficient RAM to hold all active reports and spare RAM to support refreshes to import mode models then PBIRS will have to prune out the least recently used report. It may be that there is a lot of report churn occurring due to increased usage of the service. You can review the PBIRS capacity planning white paper to see if your server provides the required resources.