none
Pass multi values parameter to SQL query RRS feed

  • Question

  • Hi,

    In my power bi i have SQL data source. I want to use IN statement in where clause so i  can filter the data.

    i want to do something like :

    SELECT * FROM Customers WHERE CustId IN (PARAMETER)

    the parameter will be a list.

    I tried to build a parameter based on list with my values but when i pass it to SQL it brings only the default value and i want all  the values.

    THE SQL

    = Sql.Database("DB", "DM", [Query="SELECT * FROM   CUSTOMERS #(lf)WHERE#(lf) CustId IN('"&TestParam&"')"])

    Any suggestions ?

    TNX

    Wednesday, July 22, 2020 4:55 PM

All replies