Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don'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.

Reply
nludwig
Regular Visitor

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:

nludwig_0-1716818206015.png


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...


 

 

2 REPLIES 2
skygold16
Helper II
Helper II

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:

nludwig_0-1716882393569.png

 

but planing the schedule refresh gives the error:

nludwig_1-1716882602494.png

 

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.