January 2020 - There is no available gateway

[Anonymous]

Hello there,

For no apparent reason, scheduled refreshes stopped working last Friday afternoon, Jan 25th.

AFAIK, everything looks ok. The on-prem Gateway is running fine and I can see that Power BI online can connect to the GW.

This is the message I receive:

Last refresh failed: Mon Jan 27 2020 09:49:57 GMT-0500 (Eastern Standard Time)
There is no available gateway

Processing error: There is no available gateway.
Cluster URI: WABI-CANADA-CENTRAL-redirect.analysis.windows.net
Activity ID: e188293d-1ee0-4dce-83d7-87502a928b36
Request ID: 438969e6-aefd-2d99-a5aa-ef3f62781116
Time: 2020-01-27 14:49:57Z
 

Thanks in advance.

[mgaynor]

Was there a resolution for this?

[Anonymous]

I'm having the same problem.

I'm using the latest December 2020 gateway, and even within powerbi service it shows that all of my data sources are mapped! it just won't let me select or apply. On my machine everything is working with the gateway, all credentials are logged in.

Thanks for your help in advance!

@GilbertQ @v-alq-msft 

[Anonymous]

I'm having the same issue, however some of the automated refreshes are working just fine on the same gateway.  Anyone have any other tips?  Thanks in advance.

[v-alq-msft]

Hi, @Anonymous 

Based on your description, you may check if the gateway is the latest version. You may encounter GatewayNotReachable when trying to set credentials for a data source. This can be the result of an outdated gateway. Install the latest gateway and try again. Morever, I'd like to suggest you use Fiddler.

Fiddler is a free tool from Telerik that monitors HTTP traffic. You can see the back and forth with the Power BI service from the client machine. This traffic list might show errors and other related information.

For further information, you can refer to the following link.

https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot

https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios

Best Regards

Allan

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

[GilbertQ]

Hi there

Can you log into the Gateway Server where you have the software installed?

Then open the On-Premise Gateway, then log in and make sure everything is running?

Also have you updated it to the latest version?