Forum Discussion
Connect to Oracle 12c with Scheduled refresh
For Power BI Report Server, has anyone made a Power BI viz that connects to Oracle and successfully put in a scheduled refresh? If so, what does the connection string look like?
Yes, it is depends what connector you are used.
If you are using "Oracle database" you must install Oracle ODAC component on RS server (ODP.NET 4).
In connection string you can use same string as you using in tnsnames. Or you can use only tns alias, in this case you must defined TNS_ADMIN enviroment variable pointing to directory of your tnsnames.ora
4 Replies
josef78Memorable Member
Yes, it is depends what connector you are used.
If you are using "Oracle database" you must install Oracle ODAC component on RS server (ODP.NET 4).
In connection string you can use same string as you using in tnsnames. Or you can use only tns alias, in this case you must defined TNS_ADMIN enviroment variable pointing to directory of your tnsnames.ora
- lbendlin
Super User
We use TNSNAMES.ORA (same on all gateway cluster members) and then the connection string is simply the TNS entry.
- lbendlin
correct
