Monitoring Gateway Availability

[RGI]

We've just installed a new gateway and some of the refreshes fail due to it being unavailable.

The error message is:
Processing error: Your data gateway is offline or could not be reached. Ensure the computer running the gateway is on during the refresh period.

Are there any tools that can be used to monitor the availability of the gateway?
Should we be monitoring from the Azure side (if at all possible) seeing as Azure reports the unavailability?
Should we be monitoring from the gateway itself (i.e. monitoring connectivity to the Azure service)?

[v-juanli-msft]

Hi @RGI

First, please check the following:

Do you use a On-premise gateway or personal gateway,?

if you use personal gateway, please make sure it running on as a application when refresh from Power BI Service.

Please do to the "Setting"->"schedule refresh" for that datasource, check which gateway you are using, whether it is running, click on the "edit credential" to see if you have given correct permission.

 

In order to use the Enterprise Gateway, just make sure you have installed and configure the on-premises gateway correctly and add all the data sources used within your dataset to the on-premises gateway on Power BI service.

Second, as you are using Azure services, go "Setting"->"schedule refresh" for that datasource, click on gateway connection there you have to select "connect directly", then configure credentials and schedule refresh.

Third, To monitor the availability of the gateway, i'm afraid there isn't any direct tool, you may refer to this troubleshooting article for gateway when you meet any issue.

Best Regards

Maggie

[RGI]

It's an on-premise gateway.

We've checked the gateway connection several times - definately set up correctly. All credentials are correct.

I'm pretty sure the gateway has been set up properly on the server itself. It's not our first gateway - we've done quite a few.

This is the second gateway that has been set up at this particular customer, and it has the exact same problem as the previous one (which was set up before we were asked to take over). I'm leaning heavily towards it being a network/infrastructure issue - but need to perform due dilligence and monitor it. None of our other customers have this problem.

[v-juanli-msft]

Hi @RGI

The paper available for download on the blog describes the approach and related considerations:

Monitor On Premises Gateway

Best Regards

maggie

[GilbertQ]

Hi there

Here are all the gateway APIs which you can use to monitor the gateway and the data sources
https://docs.microsoft.com/en-us/rest/api/power-bi/gateways

[GilbertQ]

Hi there,

I would suggest ensuring that the server is always on and always connected.

I have had Gateway servers running for a few years without any interruption

[RGI]

The server is always on, but the connected part is what I want to monitor. As far as we are concerned it should be reachable, but clearly the Azure service doesn't find it from time to time.

I have other customers with gateways that almost never fail. Our own gateways have never failed to our knowledge. Hence why I want to monitor the availability of this particular gateway from the outside and the inside - something is causing an issue.