Unable to connect to oracle database using on prime Power BI desktop

[RPBI1]

Hello, I have installed Microsoft Power BI Desktop (Optimized for Power BI Report Server - September 2025) , and I have installed "OracleClientForMicrosoftTools_x64_19 (3)" driver. I am able to connect to Oracle database using  "DBServer:PortNumber/SERVICE_NAME" . I want to use TNS Names file to connect to database but when I give TNS names its failing.  When I do TNS Ping in the command line its working fine.  What other configuration I am missing. How can I use TNS file entry while connecting to database.

Thank you,

Rajani

[v-pgoloju]

Hi @RPBI1,

Thanks for the update. Could you please accept the specific reply as the solution? If the issue was resolved on your own, kindly mark your own reply as the solution. This will help other community members who may face the same issue.

Thanks & Regards,

Prasanna Kumar

[v-pgoloju]

Hi @RPBI1,

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to @lbendlin  for prompt and helpful responses.

Just following up to see if the Response provided by community member were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[RPBI1 · Accepted solution]

Hello Prasanna and  @lbendlin  , I was able to resovle the issue. I have dowloaded incorrect drivers , I might have downloaded and installed managed drivers. But now I have dowloaded unmanaged drivers and its working. Thank you for prompt response.

[RPBI1]

Thank you Ibendlin for your reply, I did then I am getting below error. TNS ping is successful and I am able to connect to Oracle DB using Pl/sql developer.

[lbendlin]

Have a look at your PATH  environment variable.  You may have multiple clients installed and Powr BI may be looking in the wrong folder for the tnsnames.ora

[lbendlin]

if tnsping is working then you can use the tnsnames entry as the "server".