Announcing PowerON Power BI – SCSM Dashboard – 1701

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 pain out of System Center reporting. With the success of our community Power BI Configuration Manager Dashboard, I felt it was a good time to give back to the community and release PowerON BI Service Manager SCSM Dashboard – Community Edition!

With feedback from our customers and using our expert knowledge of SCSM, we’ve adapted our PowerON BI Service Manager Pro Dashboard to give the community a snippet of what is capable with Power BI and SCSM.

Written by

Raf Delgado

Raf Delgado

Product Lead


6 Jan 2017

PowerON BI Service Manager SCSM Dashboard - Community Edition

This Power BI report enables you to view Incident and Service Request information from System Center Service Manager 2012 R2 and above.

It queries the SCSM DWDataMart SQL database to retrieve SCSM information and presents it in Power BI Desktop. This then allows you to dynamically filter your data in a more visual way.

SCSM Dashboard Version

– 1711 Release Version
– Incident Overview
– Service Requests Overview
– Edit Language in settings
– Edit Company in settings
– Filter number of days returns from DW data.

Incidents (IR)

This provides an overview for incident management around:

– IR by Classifications
– IR by Support Group
– Total IR by Status
– IR by Affected Users
– IR by Assigned to Users
– IR by Urgency
– IR by Impact
– IR by Month and Year
– IR by Time Blocks *Allows you to see IR’s by raised time giving you visibility of how busy you Service Desk is by time.
– Table overview

Incident Management SCSM Dashboard

Service Requests (SR)

This provides overview information for service requests around:

– SR By Classifications
– SR By Support Group
– Total SR by Status
– SR by Affected Users
– SR by Assigned to Users
– SR by Urgency
– SR by Priority
– SR by Month and Year
– SR by Time Blocks *Allows you to see SR’s by raised time giving you visibility of how busy you Service Desk is by time.
– Table overview

Service Request Management SCSM Dashboard

SCSM Dashboard Installation Guide

Ensure you have at least read access to the SCSM SQL Database and you can access the Internet from the machine running Power BI Desktop.
Download the file and the latest Power BI desktop ( find the lastest BI desktop ).
Once installed Open Power BI.
1. Go to File > Options and Settings > Options.
2. Under Privacy enable Fast Combine to file privacy.
3. Under Security untick “Require user approval for native SQL database queries”.
Native Database Queries
4.  Select Edit Queries to load the Query Editor.
Edit Queries
5. Supply parameter information in the Setup section.
– SCSM DW SQL Server
Specify the SCSM Data Warehouse SQL Server name or instance.
– SCSM DW SQL Database
Specify the SCSM Database name (you shouldn’t need to change this unless you’ve changed the name from default).
– Language
Specify language if not using default. (Note: this is as is and not fully supported as not had chance to test)
– Organisation Name
Specify your Organisation name.
– Filter Days 
By default “0” will return all the records from the SCSM DWDatamart, if you want to limit the data returned, you can specify the number of days to returned with this field (for example, 365 days would bring back the last 365 days worth of records.


6. Select the “Incident” or “Service Request” query under the Service Manager folder and supply any credentials required to access the database.
Edit Credentials
7. If prompted, Click OK on the encryption support message.
Encryption Support
8. Close the Query Editor and load the data

Keep Up To Date - Join THe Mailing List

The team are here to help

If there are any questions and want to learn more about PowerON’s services or Solutions, please get in touch and a member of the team will be in touch shortly. 

  • PowerON, Stanley Harrison House, York, YO23 1DE
  • 0800 3029280

COntact PowerON

Leave a Reply