Forum Discussion
user parameter in dynamic query
Hello! I'm trying to pass the value of a parameter to my dynamic query statement so that I can limit the dataset on the source db (dealing with extremely large data). I tried the following......
Sorry for the delay - I was on business travel and wasn't able to check this... back now...
Looked at the link and I think I see the issue/disconnect now... I was looking for a query parameter that the user could enter and I could pass to the select statement to limit the rows returned (vs a slicer and filtering on it since the dataset is millions of records). However, using the link to query params and templates provided above, it looks like this is only possible using Desktop BI vs published reports that users are using.
If I misunderstood and there is a way to do this where the users can enter the parameter value from the report, would love to hear!
Thanks all for your feedback!!
