Forum Discussion
Connection between Power BI <- Gateway <- Oracle Database
Hi, I'm reviving this discussion because I have a similar problem.
I have a dataset that takes data from Oracle DB, I configured the necessary in locale to make PowerBI access the Oracle DB (by ODAC Driver) the PowerBI project works great on PowerBI Desktop and I go to update the dataset and related report on my workspace weekly, now we would like to automate our updates by configuring a gateway and setting an update schedule possibly using the incremental refresh.
The problem is that the server administrator is having problems adding the connection to the gateway to reach the same Oracle data source, he asked me to try to add the IP that they set in the gateway in my PowerBI Desktop, but when I try to reconnect to the server from my PBI Desktop it goes into error because I imagine that using the Oracle connector it goes to read the ODAC drivers where the server address remains the same as before.
Can anyone help us understand how to solve?
I am having the same issue. The instructions on connecting an Oracle database are apparently wrong, and we are going to open a ticket with Microsoft. Supposedly, you don't need a separate gateway for Oracle connections, but that's the only thing we haven't tried.
And yes, the gateway is up to date.
What we've done so far:
Added the 64 bit Oracle client to the gateway server
added tnsnames.ora to the server
tried connecting with the service name (fail)
tried connecting with the server name (fail)
did a tnsping from the gateway server to the Oracle database (successful)I can connect just fine on Desktop, it's the gateway connector that's not working.
