Forum Discussion

Sharmi_28's avatar
Sharmi_28
Helper I
1 year ago
Solved

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
Need Help
  • PwerQueryKees's avatar
    PwerQueryKees
    1 year ago

    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's avatar
    Akash_Varuna
    1 year ago

    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 

Akash_Varuna's avatar
Akash_Varuna
Super User
1 year ago

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