Connection between Power BI <- Gateway <- Oracle Database

[Marcel1989]

Hello,

in our company our data is in an Oracle database. In order for users to get access, they need to connect to a gateway that is interposed.

I have already put the gateway in the settings, made the connection and given my Microsoft account the read permissions. What do I have to select as data source in Power BI to now be able to read the data via the gateway?

Thanks a lot!

[Newbobotime]

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?

[KTyler]

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.

[Thejeswar]

Hi @Marcel1989 ,

Did you try Getting Data using Oracle Database Connection? You would require a Oracle Client installed in the machine to use this. Check it out!

[Marcel1989]

The administrator told me not to do that because I am supposed to connect to the gateway and not to the Oracle database. Is this still the right way? Then I would try again with the administrator this possibility.

[Thejeswar]

Hi @Marcel1989 ,

Adding Datasource to a Gateway is helpful when you want to perform a Schedule refresh of your reports. Even to build a report directly in Power BI service you would need a Published Dataset which requires it to be created in Power BI Desktop.

Per my understanding, to connect from Power BI Desktop, the only way to get data is as I shown above

For your reference, the Below link speaks in detail about the Datasource in Gateway

Add or remove a gateway data source - Power BI | Microsoft Learn