Analyzing performance monitor counters of the Microsoft on-premises data gateway and SSAS tabular databases

The Microsoft on-premises gateway enables specific cloud services including Power BI, Azure Analysis Services, PowerApps and Microsoft Flow to securely connect to on-premises data sources. In the context of Power BI, these connections support both the scheduled refresh of imported datasets stored in Power BI, as well as DirectQuery and Live Connection datasets in which only report queries and their results are exchanged between Power BI and the on-premises source. As the availability and performance of the gateway is critical for any Power BI and other supported cloud service deployment requiring on-premises data, regular monitoring of both the gateway service and its host server(s) is recommended. Additionally, given that Power BI datasets are often migrated to SQL Server Analysis Services (SSAS) to take advantage of enterprise BI features such as source control and a programmatic...