Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 mul...
  • Anonymous's avatar
    Anonymous
    6 years ago

    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