Forum Discussion
direct query parameter
Hi, I would like to create a multiselection parameter. I am working in direct query and I don't know how. I pass the parameters to the query using '"& parameter &"' but I don't know how to pass a multiselection using direct query. I would like you to open a prompt where you can choose the desired values, one or more values. This is to limit the query that returns very large row values. A thing similar to the slicer but in the parameters. Can someone help me?
Thank you
Hi Anonymous,
In fact, even if your parameter stored a list of values, you can only pick one from that list as the current value of your query parameter.
In my opinion, I'd like to suggest you create a list as a variable. Then you can use it in your connector with Text.combine function to concatenate them as text.
Regards,
Xiaoxin Sheng
3 Replies
Anonymous check this post
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
parry2k The solution you proposed is not very clear to me. Can I select more than one value in the parameter?
Hi Anonymous,
In fact, even if your parameter stored a list of values, you can only pick one from that list as the current value of your query parameter.
In my opinion, I'd like to suggest you create a list as a variable. Then you can use it in your connector with Text.combine function to concatenate them as text.
Regards,
Xiaoxin Sheng
