Forum Discussion
url query string parameters in operator character limit
If you’re anywhere near this limit, the URL approach is already fragile. Better options:
1) Use a key instead of a value list
Pass a single parameter (e.g. GroupId=123) and let the model resolve the list internally via DAX.
2) Use a table-driven filter
Have a table in the model that represents the allowed set and filter by a single identifier.
cengizhanarslan without a doubt, this is a fragile approach. But there's also the fact that 1600 <> 2000.
Joke aside, the reason why I considered query string parameters is because of maintenance overhead as I wanted to avoid having to interact with the model if when the requester changes their mind about the values to filter by. What I ended up doing was I set up a parameter in the model which can be easily edited, parsed the parameter to a list of values and used this list in the model. The parameter can easily be edited and only requires a single table refresh so minimal overhead.
Thanks!