Forum Discussion

sahiladya6993's avatar
sahiladya6993
Frequent Visitor
4 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
sahiladya6993's avatar
sahiladya6993
Frequent Visitor
4 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.