Create data source error with Oracle db in Power B...

mfmh77 · ‎04-20-2020

Database client: 12.2.0.1 64bit

PowerBi gateway: 3000.31.3

When connecting to Oracle database getting below error, please advice on this?

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:
Request ID:
Cluster URI:
Status code: 400
Error Code: DMTS_PublishDatasourceToClusterErrorCode
Time: Mon Apr 20 2020 12:05:26 GMT+0530 (India Standard Time)
Service version: 13.0.12887.307
Client version: 2003.5.00484-train
test-powerbi-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: 'Unable to find an entry point named 'OpsConIsDRCPEnabled' in DLL 'OraOps12.dll'.'
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind: Oracle
Microsoft.Data.Mashup.ValueError.DataSourcePath: dev
Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error

Greg_Deckler · ‎04-20-2020

Looks like you do not have the right Oracle drivers setup on your gateway(s)?

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...