Unanswered

Notification of On-Premise gateway failure

(0) Share

Report

Posted on by Persis

Hi All,

We have on premise gateway installed on servers, we are using this gateway in power automate flows for data synchronization between database and CRM. Sometimes the connection is lost in gateway, and the data is not in sync as the power automate flows stop triggering. Is there any way that we can set a notification of such failures, so at least we will know that something has gone wrong in gateway.

Regards,

Persis

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (0)

Sort by

lbendlin 8,716 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

There are two ways (in reality they are the same though( to report on things that are no longer there

1. Incessant polling - you need to ask your gateway cluster members "Are you still there? Are you healthy? Do you have enough disk space/memory/compute cores?" And - the most crucial of all questions: "Can you still see the proxy?" Without a working proxy your gateway is the digital equivalent of a door stopper.

2. Listening to the heartbeat of the cluster members. Have them report their telemetry every five minutes and stuff the data into a streaming dataset. But then you still need to understand when these heartbeats stop which takes you back to point 1.

This is all only looking at the physical side. On the logical side you can have a whole host of other issues like expired credentials, or changes in the data source.

In conclusion - if you want to be notified of gateway failures you have to work for it.

Was this reply helpful? Yes No
Persis 8 on at

Like (0)

Report
Copy link

Link copied!

can you please guide on how to listen if the gateway is active and send notification?

Was this reply helpful? Yes No
lbendlin 8,716 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

It's like a dead man switch on a train engine. If the driver doesn't press the "awake" button every five minutes an alert will be triggered.

You can modify this for multiple cluster members. Let's say you have five cluster members. If there aren't five new rows pushed into the streaming dataset every five minutes (with some tolerance for network delays) then you trigger an alert.

Was this reply helpful? Yes No
Persis 8 on at

Like (0)

Report
Copy link

Link copied!

are you saying that there no solution to this problem?

Was this reply helpful? Yes No
lbendlin 8,716 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
In conclusion - if you want to be notified of gateway failures you have to work for it.

Was this reply helpful? Yes No
Persis 8 on at

Like (0)

Report
Copy link

Link copied!

my question is what work has to be done, where this logic has to implemented? whether I have write a code or create a flow? if you aware of it, please provide steps?

Was this reply helpful? Yes No
lbendlin 8,716 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
how many gateway cluster members do you have? What Windows Server version are they running? Do you have RDP access to these? Can you run scheduled tasks on them without having to be logged in? Have you worked with streaming datasets (or equivalents like NewRelic) before? Have you run flows that include DAX queries?

Here is an example of a Powershell script that we are running every five minutes on all of our cluster members:

#capture stats $date = (Get-Date).ToUniversalTime().ToString('yyyy-MM-ddTHH:mm:00.000Z') $mem = (Get-Counter '\Memory\Available MBytes').CounterSamples.CookedValue $proc = (Get-Counter '\Processor(_Total)\% Processor Time').CounterSamples.CookedValue $disk = (Get-Counter '\LogicalDisk(C:)\% free space').CounterSamples.CookedValue $mashups = 0+(get-process "Microsoft.Mashup.Container.NetFX45" | Measure-Object ).Count $mashmem = 0+(get-process "Microsoft.Mashup.Container.NetFX45" | Measure-Object WS -Sum ).Sum $gwmem = 0+(get-process "Microsoft.PowerBI.EnterpriseGateway" | Measure-Object WS -Sum ).Sum $proxy = (tnc (Get-ItemProperty -Path "Registry::HKCU\Software\Microsoft\Windows\CurrentVersion\Internet Settings").ProxyServer).TcpTestSucceeded #enforce TLS1.2 [Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12 $payload = @{ "Host" = $env:computername "Timestamp" = $date "Available Memory in MB" = $mem "Processor Load %" = $proc "% Free on C:" = $disk "Mashups" = $mashups "Mashup Memory" = $mashmem "Gateway Memory" = $gwmem "Proxy ok" = $proxy+0 } #push telemetry into streaming dataset $endpoint = "https://api.powerbi.com/beta/<tenant>/datasets/<dataset>/rows?key=<API key>" Invoke-RestMethod -Method Post -Uri "$endpoint" -Body (ConvertTo-Json @($payload))

Was this reply helpful? Yes No