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 selecti...
Paginated Report
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.