Reply
dhooger
Helper I
Helper I

refresh failed because the on-premises gateway restarted - but it didn't

All of the sudden, I'm receiving this message:

"It looks like scheduled refresh failed because the on-premises gateway restarted while refresh was happening. Double-check that the data gateway is continuously running for the next scheduled refresh."

 

However, the gateway doesn't seem to be showing this.

1) Upgraded gateway per Power BI suggestion

2) rebooted machine

3) confirmed user has admin and sql rights to data

4) turned on logging. can attach but all i see is spooling blah blah blah

5) tried refreshing from the pbi

 

1 ACCEPTED SOLUTION
dhooger
Helper I
Helper I

The answer was that there were two gateways running on separate machines that were conflicting.

View solution in original post

3 REPLIES 3
v-eqin-msft
Community Support
Community Support

Hi @dhooger ,

 

Thanks for your feedback😀 Could you please Accept your reply as the solution to help the other members find it more quickly.

 

Best Regards,
Eyelyn Qin

dhooger
Helper I
Helper I

The answer was that there were two gateways running on separate machines that were conflicting.

v-eqin-msft
Community Support
Community Support

Hi @dhooger ,

 

1.On the server running this gateway, check that the service is running, and then right-click it to restart to make sure the status is Running.

gateway service stopped.png

 

2. In Power BI service, make sure the gateway is Online as shown below:

gateway setting in service.PNG

3. Two troubleshooting tools:

  • Collect logs from the on-premises data gateway app: select Diagnostics and then select the Export logs
  • Event logs : Open Event Viewer --> Applications and Services Logs-->On-premises data gateway service.

 

Refer to:

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-restart

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)