topic Paginated Report Time Out | Direct Query in Report Server

Paginated Report Time Out | Direct Query

sahiladya6993 — Tue, 04 Oct 2022 12:10:12 GMT

Hi All,

I am connecting my Power BI Report Builder to dataset using direct query.

There are multiple values in parameter around 15,000 and SELECT ALL option is enabled.

Whenever user is selecting all of the values report on tool or server showing timeout.

It works when I limit my values to 500-5000 in that parameter.

What can be possible solution to populate all of the values? Please help out.

Regards

Sahil

Re: Paginated Report Time Out | Direct Query

Anonymous — Wed, 05 Oct 2022 02:02:44 GMT

Hi sahiladya6993 ,

Paginated reports time out after 600 seconds when using Power BI DirectQuery dataset as a source.

Users who have permission to modify the properties of a published report can reset this value by editing the report definition file.

You may find it in the Dataset Properties dialog box, there's a text box where you can specify the time out duration in seconds for a specific dataset query. setting it to enough time to avoid getting the time out error.

For original post,you may refer to Solved: [Report Bulder] Where to set timeout settings for ... - Microsoft Power BI Community

Best Regards,
Community Support Team _ Caitlyn

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

Re: Paginated Report Time Out | Direct Query

sahiladya6993 — Wed, 05 Oct 2022 08:43:48 GMT

Hi,

Thanks for providing solution. But I have passed a query in Parameter which has 15000 values with SELECT ALL option enabled in it.

When user is selecting "SELECT ALL" then report builder and on server showing time out.
When I limit these values to 5000 then it works.

Is there any limit on values in parameter?

Regards

Sahil

Re: Paginated Report Time Out | Direct Query

finn881988 — Wed, 15 Nov 2023 23:24:39 GMT

I'm wondering if you solve the issue? I'm facing the same thing here.

Re: Paginated Report Time Out | Direct Query

Abdul_Muneer — Wed, 14 May 2025 08:14:54 GMT

Hi all,

PowerBI report builder latest version (v.15.7.1814.616) doesn't show Timeout option in query text editor.

Older version has this option.

Can anyone know how can increase the Time out ??