Getting CredentialMissing error during data source setting using on-premises data gateway

[krambabu]

Hi, I'm trying to connect our own data source using on-premises data gateway(enterprise mode). I wrote custom connector. chose that connector during gateway setup. Below are custom connector essential details.

1. it's an odbc datasource connector.

2. authentication type is UsernamePassword.

3. shared function accepts one required parameter. It's DSN.

4. TestConnection function is handled. (pass DSN parameter to the shared datasourcekind function).

For info DSN is configured in ODBC dataSource Administrator under sytemDSN tab where i gave service host,port,service datasource.

Now i'm trying to configure data source setting in gateway, it gives 3 text boxes 1 for DSN,2 for Username and 3rd for Password and clicked on add button. Getting below error.

DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259

Microsoft.Data.Mashup.MashupSecurityException.DataSources:	[{"kind":"Lab","path":"{\"dsn\":\"{\\\"dsn\\\":\\\"lablocal\\\"}\"}"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason:	CredentialMissing

i'm reading credentials from Extension.CurrentCredential(). dsn is required parameter("lablocal") so,it'll be passed.

Tried by hard coding the credentials too. But getting same error. Same connector is working in powerBI desktop.

Could you please help/suggest what could be the reason? How can i move forward to solve this? Can we use DSN in gateway data source adding process?

[v-angzheng-msft]

Hi, @krambabu 

Unable to reproduce your problem. 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".

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