Forum Discussion

mrbonvivant's avatar
mrbonvivant
Advocate I
8 years ago

Power BI Report Server Not Recognizing TNS Names File

On the report server I have the 64-bit Oracle database client installed and I have the TNSNames.ora file updated correctly.  I have the SQL Server instance installed on the same machine and can creat...
Report Server
TDERBY's avatar
TDERBY
Frequent Visitor
8 years ago

I am having the exact same problem with the Power BI Server. I have tried multiple ODAC versions and all seemd to be working well to connect to Oracle. I can use sqlplus to connect from a command prompt using the tnsnames.ora alias without a problem. I can create an ODBC connection and use that. But I can not create an Power BI Server Data Source object using Oracle Database type and the connection string below.

 

Data Source="MyOracleDB"

 

This same technique works fine in my 2016 SSRS service.

 

I am using Version 1.2.6648.38132 (March 2018) of the Power BI Server and ODAC 12.1.0.2.4. Both are 64 bit versions running on Windows 2012 R2.

 

I was able to connect using both work arounds in the posts above.