How to Pass List Query Parameter Value into a Powerquery to Direct Data mode

[Sharmi_28]

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

[PwerQueryKees · Accepted solution]

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

[Akash_Varuna · Accepted solution]

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 

[Sharmi_28]

@Akash_Varuna 
Thank you, I will try with text.

[PwerQueryKees · Accepted solution]

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

[Sharmi_28]

@PwerQueryKees 
Ok. Thank you.