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

I figured out a more viable workaround since I couldn't get the TNS alias to work.  I used the format of HOST":"PORT"/"SERVICE_NAME for the Oracle database and it worked!  Luckily this is short enough to use in Power BI Desktop.  Hopefully this helps someone out.

  • 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..).