Forum Discussion

Icon for Helper I rank

Helper I

4 years ago

Solved

Error 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:

V-lianl-msft
4 years ago
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:

https://docs.microsoft.com/en-us/sql/reporting-services/report-data/oracle-connection-type-ssrs?view=sql-server-ver15#64-bit-and-32-bit-drivers-for-power-bi-desktop

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

Icon for Super User rank

Super User

4 years ago

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#M733122

Installed 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.

Icon for Helper I rank

Helper I

4 years ago

Hello

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