Power BI Gateway unable to connect to on premise database

[Anonymous]

Hi,

I have been experiencing the Power BI Data Gateway unable to connect to my on-premise database. From my server, the on-premise gateway shows everything running fine, but at Power BI service, the connection of my data source shows error.

Furthermore, when run my live connection report, some visual shows up while some shows error. I suspect this is due to the recent dataset name pointing to wrong dataset when in New Look cause i saw the wrong dataset in 1-2 seconds before it turns to the correct one when i generate report.

Anyone facing this issue?

Please advise. Thanks.

[Seth_C_Bauer]

@Anonymous I would suggest you look at the logs in the Gateway. You can find them by going to the server that hosts the gateway and searching for "Gateway" in the start menu. See what the specific errors are. Also, update the gateway if you haven't in awhile. It is important that the gateway be as up to date as possible.

[Anonymous · Accepted solution]

Turns out it is due to a clone server that I created recently. The gateway duplicate ID caused this issue.