Power BI report Server slow

Hi denisciola ,

If your server is dedicated to Power BI Report Server, you can enhance performance by increasing the TotalMemoryLimit in the msmdsrv.ini file to 90–95%. This change enables the Analysis Services engine to use more of the available memory, thereby improving report efficiency.

Recommended

1. TotalMemoryLimit - 90–95%
2. LowMemoryLimit - Typically 60–70%, adjustable based on workload

After implementing these changes, it's essential to monitor system memory usage to ensure stable performance. Even on a dedicated server, tracking key performance counters will help verify that the OS retains sufficient resources.

Regards,

Yugandhar.

you're saying that the SSAS service consumes 100% of the memory.

IMHO this could mean:

- report are too expensive

- memory is not enough for your workloads

- or both

how much memory has this server?

most of the time bad performances come from bad report/model design. 

for example:
- useless data imported (this amount of data will reside in RAM)

- wrong data types

- bad DAX patterns 

- ...

have you alredy check the reports with devs?