Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.