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

Hi mrbonvivant,

 

I am new to oracle, Could u please explain step by step how you achived this workaround.

 

i installed oracle client in my system, i tested TNS connection in my system with help of sqlplus, it show connected.

 

same server is connected in Power BI desktop.

 

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