PowerBI Report Builder with Oracle database connection is not taking multiple values in where clause

Hi Team,

I have a requirement to create a paginated report out of oracle database.

The dataset works fine when i have the following sql statement 

select * from xyztable

where abc = :param1

However, when i change the where condition to in operatio like below which passed the multi value, the report doesnt work.

select * from xyztable

where abc in (:param1)

Kindly help me what im missing here.

I also tried the below expression but with no luck. 
= "select * from xyztable where abc in (" & Join(parameter!param1.value, ",") &")"