Report builder out of range error in parameters

[Anonymous]

Hi,

I'm building a paginated report on Power BI Report builder using a Dataset from Power Bi Report service as my data source. When I select the values for parameters it throws me the following error:

Specified argument was out of the range of valid values. Parameter name: parameterName

As standalone parameter it works but if  I add any other parameter it gives the out of range of valid values message.

Any idea how to fix it.

Thanks in advance

[V-lianl-msft]

Hi @Anonymous ,

When you select multiple parameters, the selected values exist in the form of a list. Try using an IN clause like max (xxx) in values (xxx).

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

[Anonymous]

Hi,

Where to put IN clause in filter section or in parameter ?

Thanks,

[Anonymous · Accepted solution]

I finally able to find the issue. I think it's a bug but one can easliy fix it mannualy. 

Issue: Getting out of range of valid values for multi-select parameters in report builder.

Reason: Power Builder not updating the correct parameter name in queries.

Solution: Manually update the queries whereever the paramter name is used mainly in main query and quries for paramters.

Regards,

Milan