cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

failed to update data source credentials:ADC:ERROR [Hype] [IBM][System I Access ADC Driver]

HI There,

 

We are successfully making a ODBC connection in the Power BI desktop with below connection string.

 

We installed a personnel gateway to schedule the report refresh on service. Unfortunately it was throwing errors.

 

Datasource Connection String : driver={iSeries Access ODBC Driver};system=MEDICAL.SC.COM;dbq=acomm;dftpkglib=QGPL;languageid=ENU;pkg=QGPL/DEFAULT(IBM),2,0,1,0,512;translate=1

 

Error Message: 

Failed to update data source credentialsSmiley SurprisedDBC:ERROR [HY000] [IBM][System I Access ODBC Driver]Key value in connection string too long.

 

Can you help me with this.

1 REPLY 1
Community Support Team
Community Support Team

Re: failed to update data source credentials:ADC:ERROR [Hype] [IBM][System I Access ADC Driver]

Hi @Anonymous 

 

You may check the document here or this thread about how to configure the odbc data source. If it is not your case,you may submit a support ticket.

https://powerbi.microsoft.com/en-us/support/

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.