Forum Discussion
How to Pass List Query Parameter Value into a Powerquery to Direct Data mode
I need to fetch the data using the DirectQuery Mode.
I have created one List Query parameter.
I want to check this parameter value in where clause.
Thanks
List type parameters are not supported. You canb aske the user to enter the values as a comma separated list, but I realize that is not ideal.
What is your use case? There may be other options...
Kees Stolker
A big fan of Power Query and Excel
Hi Sharmi_28 You can go for Text Prameters but list are not supported
Create a Text Parameter and Enter values as coma Seperated and then instead of Text.combine you could use for Text.Replace hich will convert A,B,C to 'A','B','C' which is what you want i guess
4 Replies
List type parameters are not supported. You canb aske the user to enter the values as a comma separated list, but I realize that is not ideal.
What is your use case? There may be other options...
Kees Stolker
A big fan of Power Query and Excel
PwerQueryKees
Ok. Thank you.
Hi Sharmi_28 You can go for Text Prameters but list are not supported
Create a Text Parameter and Enter values as coma Seperated and then instead of Text.combine you could use for Text.Replace hich will convert A,B,C to 'A','B','C' which is what you want i guessAkash_Varuna
Thank you, I will try with text.
