Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Problem in Gateway Connection


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,Screenshot_1.png

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.

Super User I
Super User I

Re: Problem in Gateway Connection


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. 

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

Proud to be a Super User!

Helpful resources


August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors