Forum Discussion
Performance issues with our paginated reports
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
Hi Anonymous ,
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.
1 Reply
Hi Anonymous ,
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.