Can't add Oracle data source in on-premise gateway but Power BI Desktop works fine in same machine

[Anonymous]

Hi, I'm having issue while adding a Oracle data source in our gateway. Same service name that was defined in tnsnames.ora is working on Power BI Desktop installed in the same machine as the gateway. This is the full error log:

Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details

Activity ID:	7e6371bb-7f40-4817-b304-fb289f269c1d
Request ID:	1bfc578d-3d62-5789-4d0c-5d8809aae57d
Cluster URI:	https://wabi-west-us-redirect.analysis.windows.net/
Status code:	400
Error Code:	DMTS_PublishDatasourceToClusterErrorCode
Time:	Thu Oct 08 2020 07:54:30 GMT-0700 (Pacific Daylight Time)
Service version:	13.0.14437.75
Client version:	2009.4.03166-train rms-db-pbi-gateway: Unable to connect to the data source undefined. Underlying error code: -2147467259 Underlying error message: An error happened while reading data from the provider: 'Object reference not set to an instance of an object.' DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259 Microsoft.Data.Mashup.ValueError.DataSourceKind: Oracle Microsoft.Data.Mashup.ValueError.DataSourcePath: <service name defined in tnsnames.ora> Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error

[v-yingjl]

Hi @Anonymous ,

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!

Best Regards,
Yingjie Li

[Anonymous · Accepted solution]

Hi Yingjie, fortunately, we were able to resolve this issue. After downloading the standard gateway from power bi web app using the pro account, reinstalling and restarting the machine, it worked perfectly now. Thanks!

[v-yingjl]

Hi @Anonymous ,

Based on the error message, seems like the service name defined in tnsnames.ora does not be configured correctly. Please check the service name in the file and try to set the privacy level in power bi service which is the same as in power bi desktop when connecting to Oracle.

In addition, the port number of Oracle and the firewall settings should also be configured correcly, refer these simliar issues whether it could help you:

1. https://community.powerbi.com/t5/Desktop/PowerBI-desktop-64Bit-oracle-connection-error-Object-refere...
2. https://community.powerbi.com/t5/Desktop/PowerBI-desktop-64Bit-oracle-connection-error-Object-refere...
3. https://community.powerbi.com/t5/Desktop/PowerBI-desktop-64Bit-oracle-connection-error-Object-reference/td-p/43866

Best Regards,
Yingjie Li

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

[edhans]

Did you install the Oracle drivers on the machine with the Gateway?

[Anonymous]

Yes, I did. And I verified that it's working with Power BI Desktop on the same machine.

[edhans]

This appears to be virtually identical to this issue @Anonymous - same error code 400 with same error message.

See if the solution provided there works for you.