direct query parameter

[Anonymous]

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

[parry2k]

@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.⚡

[Anonymous]

@parry2k The solution you proposed is not very clear to me. Can I select more than one value in the parameter?

[Anonymous · Accepted solution]

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.

Text.Combine 

Regards,

Xiaoxin Sheng