Error in connection to oracle

[Bladimir]

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 · Accepted solution]

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

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

[amitchandak]

@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-ver...

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.

[Bladimir]

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​