topic Re: Can't refresh reports. On-Premise Gateway / DNS Problem? in Report Server

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

Niko158 — Thu, 04 Apr 2024 14:08:45 GMT

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.

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?

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

lbendlin — Thu, 04 Apr 2024 20:54:46 GMT

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

in case of issues raise a ticket.

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

Niko158 — Fri, 05 Apr 2024 05:15:13 GMT

Thank you for your answer. I couldn't run a test yesterday, because the option is not shown under Diagnostics.

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.

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

lbendlin — Fri, 05 Apr 2024 11:33:48 GMT

Switch the additional logging off