Forum Discussion
Connect Oracle database - deprecate
Hello,
I am trying connect Oracle to Power BI desktop
I already installed Oracle Client provider, but I get a error like photo below. If anyone can help me? Thank you!
Hi , JennyMilf
First , you need to check the string connect text is right in configuration file "tnsnames.ora".
It is in directory: E:\app\client\adm.user\product\12.2.0\client_1\Network\Admin
Then you can try to use the "DLPOracle" text to the "Server" input box to try to:
Secondly , you can try to use this "ip:port/servername" in "Server" input box.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
9 Replies
Hi , JennyMilf
According to your error prompt and my understanding, Power BI Desktop does not recognize the ODAC you installed.
As seached ,for how to configure the ODAC , you can refer to :
microsoft-powerbi-connection-adw.pdf (oracle.com)Connect to an Oracle database with Power BI Desktop - Power BI | Microsoft Learn
powerbi-docs/desktop-connect-oracle-database.md at live · MicrosoftDocs/powerbi-docs · GitHub
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thank you for your response! After I follow the step in these links, I get a new error like this ...
Hi , JennyMilf
As searched , you can try to :
1.LOCATE AND COPY THE ORAONS.dll FILE IN E:Oracle11gclientproduct12.2.0client_1 Install the power BI connection oracle plugin:2.Paste the oraons.dll file into the E:Oracle11gclientproduct12.2.0client_1bin directory
You also can check if the solutions in the following similar threads help.
Solved: PowerBI desktop 64Bit oracle connection error Obj... - Microsoft Power BI Community
Solved: Re: PowerBI desktop 64Bit oracle connection error ... - Microsoft Power BI Community
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi there, check this out for oracle connection
https://www.youtube.com/watch?v=EpeJrO5tHDc
