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

can't Add Oracle Data Source to On-Premise Gateway

Hi,

 

I have installed On-Premise data geteway standard option, trying to add oracle data source getting below error

and i have refered the url: https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-manage-oracle

please help me 

 

Activity ID:de2829a0-f0ba-4547-a702-dfb920435bde
Request ID:584b8683-b990-ff83-a363-27073abac22d
Cluster URI:https://wabi-west-us-b-primary-redirect.analysis.windows.net/
Status code:400
Error Code:DMTS_UpdateClusterDatasourceCredentialsErrorCode
Time:Thu Feb 25 2021 09:47:12 GMT-0800 (Pacific Standard Time)
Service version:13.0.15430.56
Client version:2102.3.04950-train
ITFM340:Unable to connect to the data source undefined.
Underlying error code:-2147467259
Underlying error message:The provider being used is deprecated: 'OCIEnvCreate failed with return code -1 but error message text was not available.'. Please visit https://go.microsoft.com/fwlink/p/?LinkID=272376 to install the official provider.
DM_ErrorDetailNameCode_UnderlyingHResult:-2147467259
Microsoft.Data.Mashup.ValueError.Reason:DataSource.Error

 

1 ACCEPTED SOLUTION

Hi @saravanan_82 


For some reason it appears that it is not passing the username and password correctly.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

5 REPLIES 5
GilbertQ
Super User II
Super User II

Hi @saravanan_82 

 

As per the error you have an older version of the driverss installed. You need to follow the link to update the provider/driver https://go.microsoft.com/fwlink/p/?LinkID=272376

 

Also my blog post explains how to get this working

Power BI – On-Premise Gateway Configuration steps to an Oracle Database - Reporting/Analytics Made e...





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

I have Install latest Oracle client driver, later getting below error (I am using generic ID for configure the gateway)

 

saravanan_82_0-1614351624429.png

 

Hi @saravanan_82 


The error still indicates that the credentials suppled (Username and password) are not correct.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hi,

the user id and password is correct, please refer the screenshot below, i am able to connect using command prompt 

 

saravanan_82_0-1614687062301.png

please refer the error message (in the gateway setup), looks like access unauthorized showing 

saravanan_82_1-1614687331973.png

please help me for this 

 

Hi @saravanan_82 


For some reason it appears that it is not passing the username and password correctly.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors