It will most likely fail because because its a different connector which i dont think would work with powerbi server.

Your only bet is to try with positional arguments since you are using ODBC.

Select * from table where columnx = ? And columny = ?

Check this article out: https://medium.com/@kyle.hale/passing-multi-valued-parameters-from-power-bi-paginated-reports-to-dat...

It explains the steps in detail.