Power BI Paginated reports timeout after 615 seconds

Pradeep0707 — Tue, 01 Oct 2024 05:24:52 GMT

Hi ,

I have published a RDL SSRS report from Power BI Report builder to Power BI Service as a Paginated report. When I enter the parameters and run the report it is working fine for small data output - but when we run for a high data outout , getting the below error. Any help on this please?

Re: Power BI Paginated reports timeout after 615 seconds

lbendlin — Tue, 01 Oct 2024 23:35:04 GMT

It's not so much that the paginated report times out - it's the original query against the data source that takes too long. Work with the data source owner on indexes and statistics etc.

Re: Power BI Paginated reports timeout after 615 seconds

Anonymous — Tue, 08 Oct 2024 06:58:09 GMT

Thanks for the reply from lbendlin , please allow me to provide another insight:

Hi, Pradeep0707
Could you please let us know if lbendlin's response resolved your issue? If it did, kindly accept it as the solution.

I share the same view as lbendlin and recommend starting with your data queries:

1.Firstly, check if your queries can be optimised to reduce execution time. You might try simplifying the queries or breaking them down into smaller ones.

2.Secondly, you can use the CommandTimeout and ConnectionTimeout functions.

For detailed information, please refer to the following link:

c# - Increasing the Command Timeout for SQL command - Stack Overflow

SqlCommand.CommandTimeout Property (System.Data.SqlClient) | Microsoft Learn

SqlConnection.ConnectionTimeout Property (System.Data.SqlClient) | Microsoft Learn

The main differences between these two functions are as follows:

For detailed information, please refer to:

.net - What is the difference between SqlCommand.CommandTimeout and SqlConnection.ConnectionTimeout? - Stack Overflow

3.Lastly, you might also consider upgrading the gateway to see if it helps improve your issue. Here is the download link:

Power BI Gateway | Microsoft Power BI
For detailed information, please refer to the following link:
DM_GWPipeline_Gateway_AdoNetProviderExecuteQueryTimeoutError - Microsoft Q&A

Of course, if you have any new ideas, you are welcome to contact us.

Best Regards,

Leroy Lu

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

topic Re: Power BI Paginated reports timeout after 615 seconds in Developer

Power BI Paginated reports timeout after 615 seconds

Re: Power BI Paginated reports timeout after 615 seconds

Re: Power BI Paginated reports timeout after 615 seconds