Troubleshooting and monitoring gateways

For organizations with significant dependencies on the On-premises data gateway, it’s important to plan for administration scenarios, such as migrating or restoring a gateway to a different machine. Administrators should also be familiar with accessing and analyzing the gateway log files and related settings to troubleshoot data refresh issues. Finally, gateway throughput and resource availability can be monitored using Power BI template files provided by Microsoft.

In this section, we investigate each of these topics in turn.

Restoring, migrating, and taking over a gateway

Sometimes it is necessary to migrate or restore a gateway to a separate server. For example, a gateway may have initially been installed on a server with insufficient resources to support the current workload. In other cases, a hardware failure may have occurred on a gateway’s server and thus it’s necessary to quickly restore connectivity...