Problem in Gateway Connection

[manishagola]

hello,

i'm trying to connect my odbc datasource through on-premises gateway but it's not working.

i have one on-premises gateway and two diffrent data source like MySql and ODBC.

MySql is local DB in my system and for ODBC, i have created one system DSN.

Both are connect completely in PBI desktop but in PBI service only MySql data source is working completely, ODBC shows error as below screenshot,

Here i attach another screenshot in which i created two data sources in my on-premises gateway, both are successfully connected.

 

Please help me for solve this error.

Thanks in advance.

[kcantor]

@manishagola 

I would advise you to check the advanced editor on your desktop file and verify the connection is the same as you are plugging into the gateway. We have one data set that, if I am not careful, the desktop software lists slightly different. I have to manually change the pathway before publish for my gateway to access the data.