Forum Discussion
Power BI Connectivity with Oracle Database
Hi Experts,
To connect Oracle Database with Power BI Desktop, what and all to be installed in that local machine.
I want to connect the Oracle Database of 19C(19.3.0.0) with Power BI Desktop (Version: 2.88.1144.0 64-bit ). Power BI Desktop was installed in my local Windows Machine( Server 2012 R2).
I have installed only Oracle ODAC (64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64 - 287 MB) from this link (https://www.oracle.com/database/technologies/odac-downloads.html) and updated the tnsnames.ora file (E:\app\client\famis\product\12.1.0\client_1\Network\Admin) accordingly.
Now, When I opened Power BI Desktop and trying to connect the below message is appearing. Please guide me if anything I am missing.
Thanks
Santhosh
Hi santhoshpowerbi ,
You need to install the recommended provider which can be found in following links.
For32-bit versions of Power BI Desktop:
https://www.oracle.com/database/technologies/dotnet-utilsoft-downloads.htmlFor64-bit versions of Power BI Desktop:
https://www.oracle.com/database/technologies/odac-downloads.html
Please check the reply of the similar threads:
https://community.powerbi.com/t5/Desktop/Oracle-connection-error/td-p/70451/page/2
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.
1 Reply
Hi santhoshpowerbi ,
You need to install the recommended provider which can be found in following links.
For32-bit versions of Power BI Desktop:
https://www.oracle.com/database/technologies/dotnet-utilsoft-downloads.htmlFor64-bit versions of Power BI Desktop:
https://www.oracle.com/database/technologies/odac-downloads.html
Please check the reply of the similar threads:
https://community.powerbi.com/t5/Desktop/Oracle-connection-error/td-p/70451/page/2
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.