Power BI app directly connects to the billing data using the ‘Microsoft Azure Enterprise’ content pack for a quick view into the last 12 months resource consumption.Ī content pack is a connector that allows a Power BI user to connect to various services like Salesforce, Google Analytics, Microsoft Dynamics, etc. In this blog ‘Azure Billing and Usage REST API’ will be referred to as ‘API’ and ‘Azure Billing and Usage Data’ will be referred to as ‘data’ to minimize verbosity. Three possible solutions are illustrated below where the first two use Power BI as the end user reporting interface and the third is a custom UI.

This blog highlights different methods to access azure billing data with Power BI or via other alternative means when Power BI is not the best solution. There are a few things to consider with each option.

Azure Billing REST APIs – The Usage API and Rate Card API provided by the Azure Resource Manager allow users to retrieve resource consumption and billing information for an organization’s Azure subscription.Īccessing the billing data by any of the available means is not straightforward.

Power BI – Using the ‘Azure Enterprise’ content pack for Power B provides a glimpse into the last 12 months azure consumption.

As organizations move and provision resources in Microsoft Azure they find themselves with the need to analyze and monitor resource consumption for trends, review billing data to get a pulse on the organization’s return on cloud spend, and be in a better position to predict and manage operational costs.īilling and resource usage data in Azure is made available to users in two forms:

Download msdn professional license cost