Low performance for SSRS reports on Power BI Report se

[Venkat_gadde]

We are trying to host SSRS (paginated reports) on our Power BI on premise server.  To attempt resolving performance issues since we have looked at queries, report code, networking, infrastructure… we now moved a subset of our data (150k records) to a sql server database and are running power bi and sql locally.  Just as our VM/server environment has demonstrated when we first start running SSRS reports the performance is good.  If we run 6 or 7 concurrent sessions and do this several times the performance degrades.  If we reboot the server it is better again temporarily.”

[stretcharm]

RS reports should work fine with concurrent users unless the machine is underpowered or has other services. SQL will cache the data if you are using it several times. Try aggregating the 150k rows in SQL not RS.

Check the ExecutionLog3 in your ReportServer db it will show run time, data transferred and users etc.

If your running powerbi reports they can be memory hogs. Optimise them and don't have too many different large models running at the same time. Each is an SSAS cube. You can see this if you try and open a number of PBIX's on your desktop. Your memory will soon disappear.