ODBC connection error with on-premises data gateway

[HeiHo]

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)

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:

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

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

[v-diye-msft]

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