Forum Discussion
Helper IError in connection to oracle
Hello,
Can someone help me with conection to oracle? I try use oracle 19.3 and 12, but i cant....
I see this error:
Hi Bladimir ,
Power BI Desktop uses Unmanaged ODP.NET for authoring Power BI reports. You only need the following steps when using Oracle ODAC drivers 12.2 and later. Otherwise, they install by default to a non-machine-wide configuration for a new Oracle home installation. These steps assume you've installed the ODAC 18.x files to the c:\oracle64 folder for 64-bit Power BI Desktop or the c:\oracle32 folder for 32-bit Power BI Desktop. Follow these steps to register Unmanaged ODP.NET:
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
Bladimir , make sure you do steps in description of this issue
Connecting with Oracle
https://community.powerbi.com/t5/Desktop/Getting-Power-BI-Desktop-to-work-with-Oracle-ODAC-after-version/m-p/1918220#M733122Installed Oracle Driver https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-oracle-database
Add oracle install folder to global variable
I added an entry in tnsname.ora and used that.
BladimirHello
I try do it, but i have error in spet 6, when i run command
OraProvCfg /action:config /force /product:odp /component:dbproviderfactory /frameworkversion:v4.0.30319 /providerpath:Oracle.DataAccess.dll
V-lianl-msftCommunity Support
Hi Bladimir ,
Power BI Desktop uses Unmanaged ODP.NET for authoring Power BI reports. You only need the following steps when using Oracle ODAC drivers 12.2 and later. Otherwise, they install by default to a non-machine-wide configuration for a new Oracle home installation. These steps assume you've installed the ODAC 18.x files to the c:\oracle64 folder for 64-bit Power BI Desktop or the c:\oracle32 folder for 32-bit Power BI Desktop. Follow these steps to register Unmanaged ODP.NET:
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
