cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Problem in Gateway Connection

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

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

Screenshot_3.pngScreenshot_4.png 

Please help me for solve this error.

Thanks in advance.

1 REPLY 1
Highlighted
Super User I
Super User I

Re: Problem in Gateway Connection

@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. 



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

Proud to be a Datanaut!




Helpful resources

Announcements
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors