Power BI Paginated reports timeout after 615 seconds

[Pradeep0707]

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?

[v-linyulu-msft]

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?...

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.

[lbendlin]

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.