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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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.

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors