Power BI Server Cost Analysis Report for Server SLAs

Division of IT Service Level Agreement (SLA) customers now have access to a summary report showing ongoing monthly server hosting costs per server. This article provides a basic overview of the new report.

Report Descriptions

The sample report below provides a basic overview of the report's components.

Sample Power BI Server Cost Analysis report of Division of IT servers

Pages

At the top left is the Pages navigation pane where you can select Cost or PriceBreakdown report illustrations.

Cost:  This view (highlighted in red in the screen shot) is recommended and should display this by default.

PriceBreakdown:  This view will present your list of department servers and all the individual monthly costs so far.

Dept

If you have access to more than one department set of servers, you can select your departments from the drop-down. In the sample screen shot, the report is set to DoIT.

Projected Yearly Cost

This is an estimated cost for a full 12 months of server hosting.  Since you are likely to be viewing your report at any given point within the fiscal year, this is the closest estimation of what your total annual cost will be considering how much your costs have been for the past completed months plus using the most recent month's figure as the projected cost for future months. This is a projected yearly cost and does not include such future scenarios as decommissioning or adding new servers. The projected yearly cost will automatically updates based on back-end data sources and already factors in recent server changes.

Year To Date Cost Multiplied by Months

This reflects what your current year-to-date total cost is at any given point within the current fiscal year.  If all your servers were to be decommissioned at the time you are viewing the report, the Monthly Total shown here would be what your department would owe DoIT for the year's server hosting services.

Monthly Cost

This reflects what the current month's costs are based on current total server specifications (CPUs, Memory, Storage, Used Storage).  Included is a graph displaying a monthly snapshot of current and past monthly costs.  The past monthly costs are considered final costs, while the current month's cost may change if resources change within the month.

Data for Individual Servers

By default, the report will display figures for all combined servers. 

Individual Servers

If you would like to see data for individual servers, you can select a server from your list of servers and the data will update automatically to reflect data for the selected server.

Decommissioned Servers

This report will list any active servers for the current fiscal year (July 1- June 30).  If servers are formally requested to be decommissioned, DoIT will stop charging for the servers the following month. Decommissioned servers will remain listed and will drop off when the new fiscal year begins in July.  To verify that your decommissioned servers are correctly reflected in the Power BI report, simply select the server, and you should see empty values in the Monthly Cost graph.  In the sample screenshot below, there is no data for February and March because the server was decommissioned in January, and server costs will only include July through January. Monthly cost bar graph showing data in all months except February and March

Access

Existing known technical and ASM contacts are given access to their department-specific servers.  For new access requests or access removals, please submit a Service - Server Hosting request.