Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Can't choose Gateway for Oracle Direct Query connection

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

  • Anonymous's avatar
    Anonymous
    8 years ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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.