Forum Discussion
Anonymous
3 years agoNot applicable
Connect to Oracle Database
Hello Guys,
I shared a repport that is connected to Oracle Data base. It works on Desktop but it doesn't work at PowerBi Service.
Oracle client is installed on my Laptop and Tnsnames.ora is also configurated.
Any solution ?
1 Reply
- lbendlinSuper User
The Oracle database is considered an "on-premise" data source. These require you to have a gateway. Your gateway cluster members need to have the Oracle driver installed and they have to have the same TNSNAMES.ORA entry configured. After that you can create a gateway connection against the Oracle database, specifying the TNS entry's name as the server.