cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
tripleacoder Helper I
Helper I

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions
tripleacoder Helper I
Helper I

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

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)

View solution in original post

2 REPLIES 2
Super User IV
Super User IV

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

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


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

tripleacoder Helper I
Helper I

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

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)

View solution in original post

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

Attending MBAS? Claim your badge

Attending MBAS? Claim your badge

Whether you’re streaming the digital event live, or watching on-demand, claim your attendee badge to sport on your profile.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.