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
mrbonvivant's avatar
mrbonvivant
Advocate I
8 years ago

From your example the connection string should be formatted as: Data Source="192.168.12.44:1521/ISPL11GDB".

kskarthick's avatar
kskarthick
Advocate I
8 years ago

Hi mrbonvivant,

 

Thank you, its solved my issue while creating new datasource.

For existing report default it took the Connection string from which i develop in Power BI that i can't change?

 

But this is workaround you mentioned, because of this we will face any issue(like performance or ect..).

 

 

  • mrbonvivant's avatar
    mrbonvivant
    Advocate I
    8 years ago

    Correct - you can't change the connection string on the report sever once it has been sent from Power BI Desktop.  You will need to change the connection string in Power BI Desktop then republish the report.

     

    This connection string naming convention is actually a better option than using the full TNS name.  You will acheive the same performance.

    • amitsankar's avatar
      amitsankar
      Regular Visitor
      7 years ago

      I am having same issue. I have used the same format what you mentioned earlier. But i am getting same error.

       


      Oracle: ORA-12154: TNS:could not resolve the connect identifier specified