Forum Discussion
Slow On-Premise Report Server Performance /powerbi/api/explore/reports/.../querydata
The RSPortal log file was the key for our issue. There was a Windows Auth error in there that was taking up the majority of the time. We are using a Domain account for the PowerBI serveice to run under and that account did not have the privliges needed.
This sounds a bit like a resource issue if the same report is fast on desktop.
I'd start by checking the CPU and RAM usage of the server in performance monitor. And if your server is on a VM check with your VM admins that it it not using memory ballooning (or similar). VM administrators love using stuff like this as it lets them fit more servers on a host, but it kills the performance of something like Power BI which needs to access and allocate memory quickly. If your server is memory constrained it might have to evict other models from memory before loading the one for the report. If you have a VM with memory ballooning you might not see any issues on the VM, but you see strange pauses like this where the VM is requesting access to memory from the hypervisor. If the CPUs are constantly on a high percentage of usage you might need more cores or faster hardware.
Thank you d_gosbell, I should have mentioned resources in my initial post. It is definitely not that. The test report is small and if I watch the server, there is hardly even a small blip in the resources when this report is run. And the server is not be used for other task or busy at all. I will look into the VM memory settings but the test report is so small I can't imagine it is requiring a big chunk of memory to be created.
Any other suggestions?