Forum Discussion

WTDM's avatar
WTDM
New Member
3 years ago

Troubleshoot Very Slow Paginated Reports

We primarily use the PBI Service, however we have a couple onprem reports hosted in Power BI Report Server.  To consolidate, we've moved our SSRS reports to be hosted on the PBIRS Server however performance for the same reports on PBIRS vs SSRS is worse by a factor of about 10x.

 

PBIRS is running Sept 2022, and reports all come off our onprem warehouse so no gateway. It's also not hardware as the 2 servers are configured the same, same subnet, same service account... I'm using one of our simplest reports which is a select of about 600 rows from a user table - selects the whole table no WHERE clause. On SSRS it might take 2-4 seconds to render, on PBIRS it takes upwards of a minute. There appears to be 0 load on the PBIRS server or the database server.

 

I don't know if it has to spin up engines or instantiate connections or what, but there is something very different in the processing between the 2. I've looked at SQL Server logs, windows event logs...but don't see anything. Are there any logs that will have the whole flow from the request hitting the RS, or can I enable some verbose logging?

 

I'm just not sure where to go next.

No RepliesBe the first to reply