Performance issues with our paginated reports

[MARS-Abdessalem]

Hi,

We have developed our paginated reports using Power BI Report Builder. We used Microsoft SQL Server (SqlClient) to connect to the database and invoke stored procedures using input parameters.

The performance was satisfactory until we migrated our SQL Server from 2012 to 2019, and we have some doubts that this is related to SQLClient.

Which version of Microsoft SQL Server (SqlClient) should I use with Power BI Report Builder?

Below are some info about our config:

SQL Server version: Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23 Copyright (C) 2019 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2019 Datacenter 10.0 <X64> (Build 17763: ) (Hypervisor)

SQL Server Native Client 11.0

ODBC Driver 17 for SQL Server

SQL Server Native Client RDA 11.0

Thanks in davance,
Abdessalem

[Anonymous · Accepted solution]

Hi @MARS-Abdessalem ,

This does not seem to be related to the version of SQL Server. It could be that performance is slipping because you have more data, more filtering, etc. You can refer to the following documents to optimize performance:

SSRS Best Practices for Performance and Maintenance (mssqltips.com)

Diagnosing Performance of Paginated Reports in Power BI – Random Procrastination (gosbell.com)

Solved: Extremely slow paginated reports due to high conne... - Microsoft Fabric Community

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.