topic Re: Is Power BI report server naturally slow? in Report Server

Is Power BI report server naturally slow?

opejoseph — Sun, 04 Jun 2023 22:11:02 GMT

So i recently moved my power bi assets from Power BI service to my self hosted report server. I noticed it seems loading a report loads slowly when compared to power bi service. I am using a good remote server that has some capacities. I have done the best practices like reducing the joins in the report, cut schedule refresh, and optimizing queries, using the performance analyzer on desktop shows positive result too. Stakeholders get pissed off when it takes forever to see anything on their screen. Can anything be done to mitigate this?

Re: Is Power BI report server naturally slow?

lbendlin — Tue, 06 Jun 2023 01:18:17 GMT

https://www.gigxp.com/powerbi-report-server-performance-tuning/

Re: Is Power BI report server naturally slow?

josef78 — Thu, 08 Jun 2023 21:18:02 GMT

First, analyse ExecutionLog3 to check what is slow, if model processing, open report definion, model loading to memory, or dax queries. Second, check you server resources, especially memory a CPU utilisation. Also check how often are report wipe-out from memory.

For comparsion, in my enviroment, I must install second PBIRS server in scale-out mode, and dedicate background model processing to second server (and first server only as PBIRS front-end). My experience, model processing, and also dax query performance is fully comparable to cloud Power BI Service. But report open (authentificate and definition load) and load model into memory (if not already loaded), is little slow (but not big difference}

Re: Is Power BI report server naturally slow?

josef78 — Thu, 08 Jun 2023 21:18:03 GMT

Re: Is Power BI report server naturally slow?

我是天才啊11 — Fri, 09 Jun 2023 05:48:03 GMT

and dedicate background model processing to second server (and first server only as PBIRS front-end) Can you explain how to do it？

Re: Is Power BI report server naturally slow?

我是天才啊11 — Fri, 09 Jun 2023 06:03:38 GMT

I used a very simple report for testing, which can be opened in the cloud in about 3 seconds, but it takes 5 seconds locally

Re: Is Power BI report server naturally slow?

mpsrshl — Mon, 12 Jun 2023 03:56:58 GMT

It run faster in our local server than in the closest datacentre in our tests.

Re: Is Power BI report server naturally slow?

josef78 — Fri, 16 Jun 2023 06:42:04 GMT

On Front end servers, find rsreportserver.config file in your instalation folder. And set <IsDataModelRefreshService> to false.

Re: Is Power BI report server naturally slow?

我是天才啊11 — Tue, 20 Jun 2023 02:37:12 GMT

thank you