Unable to use gateway for Oracle data source

[marcodea]

Dear all I'm not able to configure On-Premises gateway to refresh a dataset that use an Oracle database. 

On Power BI desktop local file, the Oracle data source use NET_SERVICE_NAME (PVE) of tnsnames.ora file and everything works. On the gateway server I've installed 64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64.

On Power BI service, I've created a data set under gateway using the same NET_SERVICE_NAME (PVE) for Name and Server field and it seems ok.

Whe I try to set the gateway connection for the dataset, the gateway option is always gray

 

[Seth_C_Bauer · Accepted solution]

@marcodea I'm also seeing a "Web" data source in your data set there... There is a current limitation in the On Premises Data Gateay in that you are not able to combine cloud and on-premises data sources in the same dataset. You would need to use the Personal Gateway for the time being.

[marcodea]

After a full day of test, I figure out there was an issue with different kind of data source. The web data is a connection to a One Drive file.

Is it possible to configure this file via gateway?

Thanks @Seth_C_Bauer

[Seth_C_Bauer]

@marcodea Yes. But you would need to use the personal gateway, because the current implementation of the OPD gateway does not support both cloud and on-premises connections within the same dataset.