Dynamic M query with arbitrary values

Just checking have you created the dummy dimensions for both parameters?

Modified that to include s_s_n.

Updated:

let

 Source = Teradata.Database("MYPROD", [Query = " SELECT

A.NAME AS FNAME,

A.BIRTH_DT AS BDATE,

A.SSN AS SSN

FROM

EMPLOYEE A

WHERE 

A.BIRTH_DT ='"&birthdate&"' AND A.SSN = '"&s_s_n&"' " ] ),

FilterList = if Type.Is(Value.Type(s_s_n),List.Type) then s_s_n else {s_s_n},

FilteredRows = Table.SelectRows( Source,each List.Contains( FilterList,[SSN]))

in

FilteredRows

Get warning, "This step results in a query that is not supported in DirectQuery mode" on 

FilteredRows = Table.SelectRows( Source,each List.Contains( FilterList,[SSN]))

Is it that the function is not recognized by the Teradata ?

In the M code from Chris webb, what is the difference between (SalesOrderNumber) , SalesOrderNumber, {SalesOrderNumber} and [SalesOrderNumber] 

Thanks.

let
  Source = Sql.Database(
    "localhost",
    "AdventureWorksDW2017"
  ),
  dbo_FactInternetSales = Source
    {
      [
        Schema = "dbo",
        Item   = "FactInternetSales"
      ]
    }
    [Data],
  #"Removed Other Columns"
    = Table.SelectColumns(
    dbo_FactInternetSales,
    {
      "OrderDateKey",
      "SalesOrderNumber",
      "SalesOrderLineNumber",
      "SalesAmount"
    }
  ),
  FilterList = if Type.Is( Value.Type(SalesOrderNumber), List.Type)
    then SalesOrderNumber else {SalesOrderNumber},
  #"Filtered Rows" = Table.SelectRows( #"Removed Other Columns", each List.Contains( FilterList, [SalesOrderNumber]
    )
  )
in
  #"Filtered Rows"

This section relates to his blank dummy dimensions 

FilterList = if Type.Is( Value.Type(SalesOrderNumber), List.Type)

    then SalesOrderNumber else {SalesOrderNumber},

If checks if it is a list, if yes return it. If a single value it casts it as a list. These are the values passed through from the report, when user provides values

Then filters his table from SQL server, where [SalesOrderNumber] exists in the list from above

 #"Filtered Rows" = Table.SelectRows( #"Removed Other Columns", each List.Contains( FilterList, [SalesOrderNumber]

    )

Any ideas ?

Hi rnola16,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

Hi rnola16,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.