Reply
Niko158
Frequent Visitor

Can't refresh reports. On-Premise Gateway / DNS Problem?

Hello, I have a problem with data refresh through an On-Premise Gateway.
Both planned and manual refresh are causing issues. All reports are affected. It usually takes too long to refresh (over 10 min.) and then this error code is shown. There were times when I could refresh my reports manually today, but the issue kept showing later again.

2024-04-04 15_40_31-Power BI.png

I tested reports with data from different SQ servers. Then I created a new gateway on my pc and turned off the gateway we have in our virtual power bi server. The issue remained.

I started to track the data traffic and apparently the gateway is sending data to these Microsoft domains: 
g0-prod-fra21-001-sb.servicebus.windows.net
g1
g2
...
g15-prod-fra21-001-sb.servicebus.windows.net

Some of these domains return a local IP address, tested with different public DNS.
Currently, g8 is returning 10.218.0.23, g9 returns 10.218.0.24, g15 returns 10.218.0.30.
Others seem to have a public IP, like g0 with 51.116.232.39 for example, and the traffic goes through. I'm assuming this might be the reason sometimes the refresh works and sometimes it doesn't.

Is someone else having a similar problem?

1 ACCEPTED SOLUTION
Niko158
Frequent Visitor

Thank you for your answer. I couldn't run a test yesterday, because the option is not shown under Diagnostics.2024-04-05 07_06_27-powerbi - Remotedesktopverbindung.png2024-04-05 07_06_40-powerbi - Remotedesktopverbindung.png

The problem seems to have been solved today. All g0-g15 domains are now returning public IP addresses and are reachable. Every dataset is refreshing normally.

View solution in original post

3 REPLIES 3
Niko158
Frequent Visitor

Thank you for your answer. I couldn't run a test yesterday, because the option is not shown under Diagnostics.2024-04-05 07_06_27-powerbi - Remotedesktopverbindung.png2024-04-05 07_06_40-powerbi - Remotedesktopverbindung.png

The problem seems to have been solved today. All g0-g15 domains are now returning public IP addresses and are reachable. Every dataset is refreshing normally.

Switch the additional logging off 

lbendlin
Super User
Super User

on all of your gateway cluster members run a fresh network port test.  

 

lbendlin_0-1712264073398.png

in case of issues raise a ticket.

 

avatar user

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!

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.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

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