Oracle - New Gateway An invalid connection string has at least one of the passed arguments ..
We have recently configured a new gateway to replace an existing one which was situated on the same machine as the oracle database.
I have configured the new machine to house the gateway and installed the gateway, then configured Oracle 11g 64Bit client on the machine. (As i read it is best for the client version to match the database). Though normal clients are using 32Bit, i dont know if that will make a difference?
I have then gone in to the admin portal and added the connections under the gateway which say they are connected fine. The issue arises just after publishing a report that looks to DirectQuery one of the oracle connections through this new gateway. Publishing to the old gateway it works fine. Also if the report is recreated and 'import' is selected it will refresh on demand without issues.
The error we receive is when we go onto the report on the powerBI web portal - clicking the report just brings up a big white window with the below issue.
An invalid connection string has at least one of the passed arguments which does not meet the parameter specification. Please check the data source connection string. Please try again later or contact support. If you contact support, please provide these details.