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

[Anonymous]

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 credentials:ODBC:ERROR [HY000] [IBM][System I Access ODBC Driver]Key value in connection string too long.

Can you help me with this.

[v-cherch-msft]

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