upload data from query

I have a problem, 

I have update data from sql query Oracle because I have create a report from a old report created by another software.

I have in the sql query many where condition where there are condition with like "%" or IN, for example:

select * from table where filed1 IN @parameter (or variable) and field2 LIKE "%"

How convert this in power bi desktop?

Thank you