DirectQuery w. Oracle: An invalid connection string has at least one of the passed arguments

[tripleacoder]

I have published a report that uses DirectQuery against an Oracle database. I also have a Power BI Gateway set up.

All my normal reports work using the Gateway, but the Direct Query one causes this error:

"An invalid connection string has at least one of the passed arguments which does not meet the parameter specification"

The Gateway logs contain this error:

"Non-gateway exception encountered in activity scope: System.ArgumentException: Unable to find the requested .Net Framework Data Provider. It may not be installed."

Oracle database is v. 12.

Gateway is version 30000.8.452 (August 2019)
It is running on a virtual pc with Windows Server 2016.

Gateway pc has Oracle ODAC client 12.2.0.1.0 (32 bit)

I have looked in the GAC and neither Oracle.ManagedDataAccess.dll nor Oracle.DataAccess.dll is installed. Also, neither machine.config files (32- and 64 bit) contain a DbProvider reference to these dlls.
However, all the normal Import reports are working fine despite of this.

What I have tried:

Upgrading Power BI Gateway to newest version

Installing Oracle.ManagedDataAccess.dll into the GAC, and updating machine.config with a DbProvider reference
Installing Oracle Client 19 and removing Oracle Client 12

I have spent several days on this problem but the error never changes.

[Greg_Deckler]

Are you using the personal gateway or enterprise data gateway?  You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[tripleacoder · Accepted solution]

I received help from support with this.

After installing 

Oracle ODAC client 12.2.0.1.0 (64 bit) w. machine-wide configuration checked

the error went away.

(32 bit version was already installed, as well as version 19)