Forum Discussion
Offline SQL Connection in automatic data refresh but single refresh is possible
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 |
2 Replies
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.
