Create and pass a List of texts or numbers form PowerBI to WHERE clause in Teradata

[Will_Ryu]

Hi all

I am new  to Power BI and would like to pass a list of identifiers ( say 100 numbers or names) from a PowerBI Desktop query to a Teradata table to get some attributes

How do I do this in PowerBI (create and pass the list) so I can filter the large Teradata table using the WHERE clause? 

= Teradata.Database ("Database", [Query =" Select * from table  WHERE table.fieldname IN (listof identifiers form PowerBI)"])

Thanks

[amitchandak · Accepted solution]

@Will_Ryu , Try if you can use a column like this

Teradata.Database ("Database", [Query =" Select * from table WHERE table.fieldname IN ('" & Text.Combine(Date[Column]"','") &"')"])

Column is treated as List (power query list)

[Will_Ryu]

A follow up question

If I need an apostrphe in front, how would I do that

I tried  - " '" & Text.Combine(Source [Name] ,"' ,") but the output I get only has an apostrophe for the first item like so 'Will', Sam', Jo,  

What I need is - 'Will', 'Sam', 'Jo', 

Do i have to convert the list to a table, add the delimiters and then convert back to a list

Thanks

Thanks

[Will_Ryu]

Thanks Amit 

That worked great but with one change.  For a column with whole numbers, I had to change it to text before the formula worked.

I also deleted some of the " as it wasn't working

("& Text.Combine(PBI_query[column] ,",") &")