Using Power BI and OMS to visualize performance information[Updated 11/29/2017: for the new query language for Log Analytics]
In the previous blog post we reviewed how OMS can be integrated with Power BI to visualize security information (including how to activate Power BI integration with OMS). In this blog post we will look at how the same concepts can be applied to performance information by sending performance information from OMS to Power BI.
Sending performance information from OMS to Power BI:
To gather performance data, we can use a starting query such as this:
From there we can export our performance information to Power BI using the Power BI button. If we wanted to filter this query we can do so by specifying which Computer, ObjectName, CounterName, InstanceName or CounterPath we want to send to Power BI. Additionally, if we wanted to filter this data by the amount of data we could send only aggregated data, averaged data or only data from a specific time range (see the OMS search reference for example at: https://technet.microsoft.com/en-us/library/mt450427.aspx).
Sample Power BI dashboard:
Using the cards above we can select a specific Computer, ObjectName or CounterName to alter what our performance chart shows at the bottom of the screen. In the example below a single computer has been selected and a single CounterName (% Committed Bytes in Use).
Summary: This second type of integration of OMS and Power BI continues to show some incredible potential methods to visualize data. In the next blog post in this series we will show how this approach can be used to visualize event and alert information.