Automation Series 1, Part 3: Power BI Reporting

Summary

In the third post of our automation series we will focus on report and dashboard creation from within the Power BI web app. The intent of our dashboard today will be to show only a few key metrics:

  1. Incident creation by date
  2. Count of Incidents by classification
  3. Count of Incidents by Status

Continue reading “Automation Series 1, Part 3: Power BI Reporting”

Automation Series 1, Part 2: Powershell and Power BI

Summary

In the second part of our series we will be focusing on Power BI and how to access the API through Powershell, as well as the benefits of using the API. We will also discuss a few of the limitations that exist within the API currently that could limit what you want to do with the API.

This is part 2 in the series, if you are looking for the first post you can find it here:

Automation Series 1, Part 1: Service Manager Dashboards in Power BI through Azure Automation

Continue reading “Automation Series 1, Part 2: Powershell and Power BI”

Automation Series 1, Part 1: Service Manager Dashboards in Power BI through Azure Automation

Summary

This blog is the first in a series that I’ll be writing, starting today and continuing through the next few weeks, that will focus on how IT shops can easily automate the process of dashboard creation within Power BI and then present this information to their users in a very mobile friendly fashion through the Power BI app. Going a step further, we will use Microsoft’s Azure Automation in the cloud to run on-premise runbooks to collect the data from Service Manager and upload the data into Power BI using Powershell and the Power BI API.

Continue reading “Automation Series 1, Part 1: Service Manager Dashboards in Power BI through Azure Automation”