Offline SQL Connection in automatic data refresh but single refresh is possible

[nludwig]

Hi Community,

I am using a mysql Connection with the Connector Gateway and daily automatically refresh of the data. Yesterday the database hardware was down and our admin configured a new server. Every setting is same then before. I am able to refresh the data manually in the semantic modell:

But when I try to reactivate the automatic refresh I get no connection to the sql server. This is strange when it works manually but not autmatically?

I have no idea what happened and how I can solve it .. Does anybody has an idea? Thank you Nicole

Fehler beim Aktualisieren der Datenquellen-Anmeldeinformationen: An error happened while reading data from the provider: 'One or more errors occurred.'Details ausblenden

Aktivitäts-ID:	0dc3065d-0b46-43ee-ad1b-7b492a153e26
Anforderungs-ID:	c1d65740-0ca5-3c3d-1a65-026b9e066a5b
Statuscode:	400
Zeit:	Mon May 27 2024 15:57:46 GMT+0200 (Mitteleuropäische Sommerzeit)
Dienstversion:	13.0.23358.54
Clientversion:	2405.3.19359-train
Cluster-URI:	https://wabi-west-europe-d-primary-redirect.analysis.windows.net/ Fehlercode: UnknownError Verbindungsfehler: Unbekannter Fehler Cluster-URI: https://api.powerbi.com Sitzungs-ID: eceeb10e-7cf4-4b30-8945-67f5b56cda76 Anforderungs-ID: 6a6fd08e-7d...

[skygold16]

Hi @nludwig 

When you say you are able to refresh manually, do you mean on the desktop? if yes, then your DB admin need to whitelist the incoming request coming from the gateway machine. In my experience, whenever admin build new machine and if you are not able to refresh it from the services, most of the time it is firewall and proxy routing related issue. You need to talk to your internal networking team to understand the network traffic flowing from Power BI service to your onprem data source. 

[nludwig]

Thank you @skygold16  .. It is weired, I can update by click on the refresh button in the app:

but planing the schedule refresh gives the error:

I - and the admins - dont believe it's a server configuration thing. Do you have another idea? Thanks Nicole