Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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 |
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.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
32 | |
26 | |
23 | |
19 | |
16 |
User | Count |
---|---|
49 | |
38 | |
24 | |
20 | |
20 |