Connect to Oracle 12c with Scheduled refresh

[bryanshaw46]

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?

[josef78 · Accepted solution]

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]

correct

[lbendlin]

We use TNSNAMES.ORA  (same on all gateway cluster members) and then the connection string is simply the TNS entry.

[bryanshaw46]

Just to be clear lbendin, in the Connection String text box, the only thing in there is the tns entry.  Nothing else.  Correct?