The ConfigMgr Dashboards Died what happened?! Following Microsoft’s announcement changing the service periods for Windows 10 to 30 months; it looks like the amendments to the Windows life-cycle fact sheet has broken the Power BI ConfigMgr Current Branch Dashboard. RIP OS Support Life Cycle Page… For Now This change unfortunately means that sadly the […]
Yo! It’s been a busy month around PowerON and the The DevOps Hub for me; I’ve been working on or getting some improvements to the dashboard and addressing some issues along the way. With this in mind, here is the update for the Power BI – ConfigMgr Current Branch Dashboard 1806 🙂 Power BI – […]
The PowerON Power BI Configuration Manager Dashboard 1612 is now out! With the 1611 version We’ve had some great feedback from the community and made some minor changes to the queries as well as adding some additional support information from Microsoft. Version 1611 Release Notes•Included Branch Support information from https://docs.microsoft.com/en-us/sccm/core/servers/manage/current-branch-versions-supported into the admin settings. •Addressed […]
Traditionally getting the most out of reporting in Service Manager (SCSM) can be challenging. Gaining the visibility and information out of the reports, can be time consuming and difficult, using SQL reports or excel pivot tables to get the information required. At PowerON we’ve been working hard to make reporting more accessible and take the […]
The next installment of the Power BI Configuration Manager Dashboard is here! We’ve been busy making some changes to the successful 1.4 version which we brought out back in July. We’re now over 4000 downloads on the technet gallery and can’t believe the positive response from the community. With the ever progressing Power BI (BI) […]
Like most people, I’ve been having major withdrawal symptoms from Game of Thrones (GoT) recently and was left wondering what to do until next year to get my GoT fix! After watching a few YouTube theory videos and restarting the series from season one, I started tothink (being the geek I am) how cool it […]
Power BI Desktop June 2016 Update – Part 1 – Functions So in my previous post, I explained how functions have changed and how you can convert existing queries to a function. In this post I’ll continue with my original issue of using multiple queries but using parameters to connect to one SQL server/db. With […]
I created a post a while back on invoking functions to specify parameters for data queries (Link Here). This was happily working using a single function to update multiple queries… until what seems to be the May/June Update. This introduced inline functions and parameters to the BI desktop, which caused me a bit of pain on […]
It’s been a busy couple of months for me on the Power BI front. Following the success of my Power BI SCCM Dashboard (see previous post here), I’m pleased to announce version 1.4! This version is a little different though as its the first version with the PowerON brand and its packed with improvements for […]
Back in 2011 Steve Beaumont created an awesome post on SCOM Distributed App Dashboard. I decided to use this post to replicate the dashboard in Power BI! The SQL Query To retrieve the information required, we’ll use the below updated SQL script to pull back the information required. SELECT BaseManagedEntity.DisplayName AS ‘Application’,MAX(State.HealthState) […]
