Can't choose Gateway for Oracle Direct Query connection

[Anonymous]

Hi,

To separate dev and production environments, I created a dev computer (which can only connect do dev database) and a gateway computer (which can connect to production database). But when I publish an Oracle Direct Query data source, there hasn't any option to choose Gateway to connect to production database.

So, is there any way to choose Gateway for Oracle Direct Query? Is it a bug or a missing feature?

PS: I can choose gateway fine with Oracle Import connections

[Seth_C_Bauer · Accepted solution]

@Anonymous You would need to change the PBIX file connection in the Desktop and re-deploy the report. It would pick up the new production connection on the other gateway. There is no way to swap data sources via the Service.