Forum Discussion

sahiladya6993's avatar
sahiladya6993
Frequent Visitor
3 years ago

Paginated Report Time Out | Direct Query

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

 

Paginated Report

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.

    • sahiladya6993's avatar
      sahiladya6993
      Frequent Visitor
      3 years ago

      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 

       

      • finn881988's avatar
        finn881988
        Frequent Visitor
        2 years ago

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

  • Abdul_Muneer's avatar
    Abdul_Muneer
    Regular Visitor
    1 year ago

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