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

ODBC connection error with on-premises data gateway

Hello PowerBI team,

 

We are getting this error, when trying to connect to our ODBC data source via the on-premises data gateway

 

(DMTS_PublishDatasourceToClusterErrorCode)

 

2019-10-17_Screenshot ODBC Fehler.jpg

 

Looks like running into a timeout.

 

Background:

We have set up a On-premises data gateway on a Windows Server 2012 machine. We have set up a System-DSN on the server like this:

 

2019-10-17_Screenshot ODBC Treiber.jpg

 

On PowerBI it looks like, the gateway is online. The setup of the data connection looks like this:

 

2019-10-17_Screenshot ODBC Datenquelle.jpg

 

When I try to connect with Excel Power BI on the server, its working well. Also, I have installed the On-premises data gateway (not the personel mode) on my local computer. With the same configuration, the connection is working well. We tried already, to turn off the firewall on the server. Nothing helped.

 

Some ideas, what to do? Would appreciate any help on this. Thanks in advance.

 

Heinrich

1 REPLY 1
Community Support Team
Community Support Team

Re: ODBC connection error with on-premises data gateway

Hi @HeiHo 

 

Please kindly following troubleshooting guide

https://docs.microsoft.com/en-us/power-bi/service-gateway-proxy#changing-the-gateway-service-account...

 

start run services

then for on-premises data gateway service

on the tab log on changed the user to use

Local Service Account
Y=Allow service to interact with desktop

 

then recovered the gateway using the recovery key

 

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

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 326 members 2,617 guests
Please welcome our newest community members: