Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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 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.
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
@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.