unable to connect to oracle database

[mmm286b]

Hi,

I'm trying to connect to oracle Database 19c with Power BI Desktop 64 bits

I follow the guide https://www.oracle.com/a/ocom/docs/database/microsoft-powerbi-connection-adw.pdf

I've installed oracle client and I put tnsnames.ora and sqlnet.ora but when I select Oracle database it says me:

I search in forums but I can't see correct answer. Any help please?

Thanks

[Anonymous]

Thanks for the reply from collinq  and tharunkumarRTK , please allow me to provide another insight: 
Hi  @mmm286b ,

Did the above replies help you?

You can try the link below with the same error message and check the following:

Verify that the tnsnames.ora file is properly configured and that you are using the correct net_service_name. also make sure that the net_service_name is the same between the computer using Power BI Desktop and the computer running the gateway.

Solved: Not able to connect to an Oracle database with Pow... - Microsoft Fabric Community

This is the related document, you can view this content:

Solved: Oracle Connection error 'Oracle.DataAcess.Client' ... - Microsoft Fabric Community

Solved: Oracle connection error - Microsoft Fabric Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[collinq]

HI @mmm286b ,

You also have to install the Oracle bits on your Gateway Server.  Take a run at that and let us know how it goes.

[tharunkumarRTK]

@mmm286b 

Conisdering you have 64 bit power bi desktop installed, just check if you have installed 64 bit oracle client. Make sure you have all the configurations in place, if you are connecting to an on premises oracle db then you need to have tnsnames file in the right location and you should place its path as an environment variable (ex: TNS_ADMIN)

refer this video and also the below thread 

https://www.youtube.com/watch?v=EpeJrO5tHDc

https://community.fabric.microsoft.com/t5/Desktop/Connect-Oracle-database-deprecate/m-p/3057538

if you are still facing the issue then I would suggest you to uninstall power bi desktop and download it fromt he web (not from the microsoft store) and see if that helps

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!