Multiple value in parameter with direct query

[Anonymous]

Good evening, I have a problem:

I have thi sql statement

select * from table1 where field1 in (parameter)

The parameter can has two or more value, for example parameter = ('A','B','C')

In the sql oracle I don't have any problem but:

"I must use direct query for import the data, how I can introduce multiple value in parameter?"

I usually use this statement

1 - I create a parameter in power bi desktop

2 - I take the sql statement and use '" &parameter& "' in the parameter 

In particular:

select * from table1 where field1 in ('"  &nameParameterPowerBi&"')

You can help me?

Thank you

Best regards

[amitchandak]

@Anonymous , Are you looking for this option

https://community.powerbi.com/t5/Desktop/parameterize-connection/m-p/205900#M90712

[Anonymous · Accepted solution]

I found a solution.

It is enough to remove the ' in the query sql when I write the sql statement.

So my sql statement with parameter become:

select * from table1 where field in (" &paramenter& ")

and in the parameter in power bi I add 'value','value', so it will become in the direct query when it run

select * from table1 where field in ( 'value','value')

Best regard