This Power BI Template (PBIT) is an accelerator to help organizations quickly monitor, visualize, analyze and govern Azure usage, costs, trends, and anomalies. It is designed to augment the Azure Cost Management APIs with organizational metadata to help establish deeper Azure cost management governance. The template enables extensive drill-down into all Azure costs and analyzes those costs against organizational defined Tags such as Application, Cost Center, Division, Business Unit, Owner etc.
This templates uses the Azure Cost Management Connector for Power BI Desktop
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-azure-cost-management
To connect, you must use an Enterprise Administrator account for Enterprise Agreements, or have appropriate permissions at the billing account or billing profile levels for Microsoft Customer Agreements.
v11.28.23 (Current)
v3.19.23
v3.14.23
v3.10.23
v2.17.23b
v11.28.23 (Current)
v3.19.23
v3.10.23
Note as of 11/28/23: Currently updated for v3.19.23. Will publish updated installation documentation for v11.28.23.
This Power BI Cost Management template is designed for Enterprise Agreement (EA) Accounts.
It would need to be modified for Microsoft Customer Agreement (MCA) or Pay-as-you-go (PAYGO) agreements.
https://learn.microsoft.com/en-us/azure/cost-management-billing/understand/understand-usage
(1) Azure Cost Management API - Data Available through the Connector
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-azure-cost-management#data-available-through-the-connector
Cost Management Tables
- Budgets (budgets)
- Pricing Sheet with Enterprise Discount (pricesheets)
- Usage (usagedetails)
- Amoritized Usage (usagedetailsamortized) (NOTE: Default Cost Table used in Template)
- Reservation Charges (richarges) (Depreciating) (NOTE: Not used in Template)
- Reservation Transactions (ritransactions) (Replacing Resevation Charges)
- RI Recommendations - Single (rirecommendationssingle)
- RI Recommendations - Shared (rirecommendationsshared)
- RI Usage Detail (riusagedetails)
- RI Usage Summary (riusagesummary)
- Balance Summary - Current Period (balancesummary)
(2) Cost Mangement Automation - Long-Term Storage
This Power BI Connector template does not store cost management data to long-term persistent storage. For automating cost management data to long-term storage, please reference the APIs - https://learn.microsoft.com/en-us/azure/cost-management-billing/automate/automation-overview#available-apis
(3) Azure Cost Management + Billing Documentations (Best Practices)
https://learn.microsoft.com/en-us/azure/cost-management-billing/
- Product Documentation
- Manage and Optimize Costs
- Cost Management Best Practices
- How-To and Trainng
(4) Azure Cost Management (Learn)
https://learn.microsoft.com/en-us/power-query/connectors/azurecostmanagement
(5) Azure Cost Management Discipline, Best Practices, Governance Templates/
https://learn.microsoft.com/en-us/azure/cloud-adoption-framework/govern/cost-management/
- Cost Management Discipline Template
- Cost Management Tools in Azure - Native Tools for Policy and Process Automation
- Cost Management sample Azure Policy statements
- Cost Management Best Practices
- Cost Management Discipline Improvement
(6) Considerations and Limitations (e.g. 1GB PBIX)
https://learn.microsoft.com/en-us/power-query/connectors/azurecostmanagement#considerations-and-limitations
(7) Microsoft Management Videos - Best Practices (YouTube)
https://www.youtube.com/c/AzureCostManagement
(1) Microsoft Cost Management App (Microsoft AppSource)
https://appsource.microsoft.com/en-US/product/power-bi/costmanagement.azurecostmanagementapp
(2) Chris Bowman Github Template
https://github.com/chris-bowman/Azure-Cost-Reporting
The Power BI Azure Cost Management Template uses Azure Architecture Icons (SVG)
Azure Icons - https://learn.microsoft.com/en-us/azure/architecture/icons/
Power Platform Icons - https://learn.microsoft.com/en-us/power-platform/guidance/icons
M365 Icons - https://learn.microsoft.com/en-us/microsoft-365/solutions/architecture-icons-templates?view=o365-worldwide
D365 Icons - https://learn.microsoft.com/en-us/dynamics365/get-started/icons
Please review icons terms of use prior to use. Architecture Icons are not included in this Github repository.
Microsoft permits the use of these icons in architectural diagrams, training materials, or documentation. You may copy, distribute, and display the icons only for the permitted use unless granted explicit permission by Microsoft.
Azure News and Cost Management Announcements are pulled directly from the following RSS Feeds
(1) Azure Updates - https://azurecomcdn.azureedge.net/en-us/updates/feed/
(2) Azure Announcements - https://azurecomcdn.azureedge.net/en-us/blog/topics/announcements/feed/
(3) Azure Cost Management News - https://azurecomcdn.azureedge.net/en-us/blog/tag/cost-management/feed/
(4) Power BI - https://powerbi.microsoft.com/en-us/blog/feed/
The Power Automate Flows and SQL Schema are not included in the current template version. It will be availabe in a future release.
THE SCRIPTS ARE PROVIDED AS IS WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING ANY IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE, MERCHANTABILITY, OR NON-INFRINGEMENT.
Please contact Rob Wilson rowilson@microsoft.com | Follow Me on Twitter @robswilson
This project welcomes contributions and suggestions. Most contributions require you to agree to a Contributor License Agreement (CLA) declaring that you have the right to, and actually do, grant us the rights to use your contribution. For details, visit https://cla.opensource.microsoft.com.
When you submit a pull request, a CLA bot will automatically determine whether you need to provide a CLA and decorate the PR appropriately (e.g., status check, comment). Simply follow the instructions provided by the bot. You will only need to do this once across all repos using our CLA.
This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.