Analyze Azure costs with the Power BI App - Microsoft Cost Management (2023)

  • Article
  • 9 minutes to read

This article explains how to install and use the Cost Management Power BI app. The app helps you analyze and manage your Azure costs in Power BI. You can use the app to monitor costs, usage trends, and identify cost optimization options to reduce your expenditures.

The Cost Management Power BI app currently supports only customers with an Enterprise Agreement.

The app limits customizability. If you want to modify and extend the default filters, views, and visualizations to customize for your needs, use Cost Management connector in Power BI Desktop instead. With the Cost Management connector you can join additional data from other sources to create customized reports to get holistic views of your overall business cost. The connector also supports Microsoft Customer Agreements.


Power BI template apps don't support downloading the PBIX file.


  • A Power BI Pro license is required to install and use the app.
  • To connect to data, you must use an Enterprise Administrator account. The Enterprise Administrator (read only) role is supported.

Installation steps

To install the app:

  1. Open Cost Management Power BI App.

  2. On the Power BI AppSource page, select Get it now.

  3. Select Continue to agree to the terms of use and privacy policy.

  4. In the Install this Power BI app box, select Install.

  5. If needed, create a workspace and select Continue.

  6. When installation completes, notification appears saying that your new app is ready.

    (Video) Azure Cost Management - Power Bi

  7. Select the app that you installed.

  8. On the Getting started page, select Connect your data.

  9. In the dialog that appears, enter your EA enrollment number for BillingProfileIdOrEnrollmentNumber. Specify the number of months of data to get. Leave the default Scope value of Enrollment Number, then select Next.

  10. The next installation step connects to your EA enrollment and requires an Enterprise Administrator account. Leave all the default values. Select Sign in and connect.

  11. The final dialog connects to Azure and gets data. Leave the default values as configured and select Sign in and continue.

  12. You are prompted to authenticate with your EA enrollment. Authenticate with Power BI. After you're authenticated, a Power BI data refresh starts.


    The data refresh process might take quite a while to complete. The length depends on the number of months specified and the amount of data needed to sync.

After the data refresh is complete, select the Cost Management App to view the pre-created reports.

Reports available with the app

The following reports are available in the app.

(Video) Azure Cost Management Tutorial | Analyzing and reacting to changes in billing

Getting Started - Provides useful links to documentation and links to provide feedback.

Account overview - The report shows the current billing month summary of information, including:

  • Charges against credits
  • New purchases
  • Azure Marketplace charges
  • Overages and total charges

The Billing account overview page might show costs that differ from costs shown in the EA portal.


The Select date range selector doesn’t affect or change overview tiles. Instead, the overview tiles show the costs for the current billing month. This behavior is intentional.

Data shown in the bar graph is determined by the date selection.

Here's how values in the overview tiles are calculated.

  • The value shown in the Charges against credit tile is calculated as the sum of adjustments.
  • The value shown in the Service overage tile is calculated as the sum of ServiceOverage.
  • The value shown in the Billed separately tile is calculated as the sum of chargesBilledseparately.
  • The value shown in the Azure Marketplace tile is calculated as the sum of azureMarketplaceServiceCharges.
  • The value shown in the New purchase amount tile is calculated as the sum of newPurchases.
  • The value shown in the Total charges tile is calculated as the sum of (adjustments + ServiceOverage + chargesBilledseparately + azureMarketplaceServiceCharges).

The EA portal doesn't show the Total charges column. The Power BI template app includes Adjustments, Service Overage, Charges billed separately, and Azure marketplace service charges as Total charges.

The Prepayment Usage shown in the EA portal isn't available in the Template app as part of the total charges.

Usage by Subscriptions and Resource Groups - Provides a cost over time view and charts showing cost by subscription and resource group.

Usage by Services - Provides a view over time of usage by MeterCategory. You can track your usage data and drill into any anomalies to understand usage spikes or dips.

Top 5 Usage drivers - The report shows a filtered cost summarization by the top 5 MeterCategory and corresponding MeterName.

Windows Server AHB Usage - The report shows the number virtual machines that have Azure Hybrid Benefit enabled. It also shows a count of cores/vCPUs used by the virtual machines.

(Video) Azure Cost Reporting Template in Power BI

The report also identifies Windows VMs where Hybrid Benefit is enabled but there are less than 8 vCPUs. It also shows where Hybrid Benefit is not enabled that have 8 or more vCPUs. This information helps you fully use your Hybrid Benefit. Apply the benefit to your most expensive virtual machines to maximize your potential savings.

RI Chargeback - The report helps you understand where and how much of a reserved instance (RI) benefit is applied per region, subscription, resource group, or resource. The report uses amortized usage data to show the view.

You can apply a filter on chargetype to view RI underutilization data.

For more information about amortized data, see Get Enterprise Agreement reservation costs and usage.

RI Savings - The report shows the savings accrued by reservations for subscription, resource group, and the resource level. It displays:

  • Cost with reservation
  • Estimated on-demand cost if the reservation didn't apply to the usage
  • Cost savings accrued from the reservation

The report subtracts any under-utilized reservation waste cost from the total savings. The waste wouldn't occur without a reservation.

You can use the amortized usage data to build on the data.

VM RI Coverage (shared recommendation) - The report is split between on-demand VM usage and RI VM usage over the selected period. It provides recommendations for VM RI purchases at a shared scope.

To use the report, select the drill-down filter.

Select the region that you want to analyze. Then select the instance size flexibility group, and so on.

For each drill-down level, the following filters are applied to the report:

  • The coverage data on the right is the filter showing how much usage is charged using the on-demand rate vs. how much is covered by the reservation.
  • Recommendations are also filtered.

The recommendations table provides recommendations for the reservation purchase, based on the VM sizes used.

The Normalized Size and Recommended Quantity Normalized values help you normalize the purchase to the smallest size for an instance size flexibility group. The information is helpful if you plan to purchase just one reservation for all sizes in the instance size flexibility group.

(Video) Azure Cost Management Overview

VM RI Coverage (single recommendation) - The report is split between on-demand VM usage and RI VM usage over the selected time period. It provides recommendations for VM RI purchases at a subscription scope.

For details about how to use the report, see the VM RI Coverage (shared recommendation) section.

RI purchases - The report shows RI purchases over the specified period.

Price sheet - The report shows a detailed list of prices specific to a Billing account or EA enrollment.

Troubleshoot problems

If you're having issues with the Power BI app, the following troubleshooting information might help.

Error processing the data in the dataset

You might get an error stating:

There was an error when processing the data in the dataset.Data source error: {"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"We cannot convert the value \"Required Field: 'Enr...\" to type List."}}],"exceptionCulprit":1}}} Table: <TableName>.

A table name would appear instead of <TableName>.


The default Scope value of Enrollment Number was changed in the connection to Cost Management.


Reconnect to Cost Management and set the Scope value to Enrollment Number. Do not enter your organization's enrollment number, instead type Enrollment Number exactly as it appears in the following image.

BudgetAmount error

You might get an error stating:

Something went wrongThere was an error when processing the data in the dataset.Please try again later or contact support. If you contact support, please provide these details.Data source error: The 'budgetAmount' column does not exist in the rowset. Table: Budgets.


This error occurs because of a bug with the underlying metadata. The issue happens because there's no budget available under Cost Management > Budget in the Azure portal. The bug fix is in the process of getting deployed to the Power BI Desktop and Power BI service.


  • Until the bug is fixed, you can work around the problem by adding a test budget in the Azure portal at the billing account/EA enrollment level. The test budget unblocks connecting with Power BI. For more information about creating a budget, see Tutorial: Create and manage Azure budgets.

Invalid credentials for AzureBlob error

You might get an error stating:

Failed to update data source credentials: The credentials provided for the AzureBlobs source are invalid.


This error occurs if you change the authentication method for your data source connection.

(Video) Analyze, manage, and optimize your cloud cost with Azure Cost Management (BRK3190)


  1. Connect to your data.
  2. After you enter your EA enrollment and number of months, make sure that you leave the default value of Anonymous for Authentication method and None for the Privacy level setting.
  3. On the next page, set OAuth2 for the Authentication method and None set for Privacy level. Then, sign in to authenticate with your enrollment. This step also starts a Power BI data refresh.

Data reference

The following information summarizes the data available through the app. There's also links to APIs that give in-depth details for data fields and values.

Table referenceDescription
AutoFitComboMeterData included in the app to normalize the RI recommendation and usage to the smallest size in the instance family group.
Balance summarySummary of the balance for Enterprise Agreements.
BudgetsBudget details to view actual costs or usage against existing budget targets.
PricesheetsApplicable meter rates for the provided billing profile or EA enrollment.
RI chargesCharges associated to your reserved instances over the last 24 months.
RI recommendations (shared)Reserved instance purchase recommendations based on all your subscription usage trends for the last 7 days.
RI recommendations (single)Reserved instance purchase recommendations based on your single subscription usage trends for the last 7 days.
RI usage detailsConsumption details for your existing reserved instances over the last month.
RI usage summaryDaily Azure reservation usage percentage.
Usage detailsA breakdown of consumed quantities and estimated charges for the given billing profile in the EA enrollment.
Usage details amortizedA breakdown of consumed quantities and estimated amortized charges for the given billing profile in the EA enrollment.

Next steps

For more information about configuring data, refresh, sharing reports, and additional report customization see the following articles:

  • Configure scheduled refresh
  • Share Power BI dashboards and reports with coworkers and others
  • Subscribe yourself and others to reports and dashboards in the Power BI service
  • Download a report from the Power BI service to Power BI Desktop
  • Save a report in Power BI service and Power BI Desktop
  • Create a report in the Power BI service by importing a dataset


Which of the following tools provides us the ability to analyze Azure costs and makes cost savings recommendations? ›

Cost Management works with Azure Advisor to provide cost optimization recommendations. Azure Advisor helps you optimize and improve efficiency by identifying idle and underutilized resources.

How do you analyze cost in Azure? ›

To review your costs in cost analysis, open the scope in the Azure portal and select Cost analysis in the menu. For example, go to Subscriptions, select a subscription from the list, and then select Cost analysis in the menu. Use the Scope pill to switch to a different scope in cost analysis.

Can you use Azure cost management to view costs associated to management? ›

Users can view costs by navigating to Cost Management + Billing in the Azure portal list of services. Then, they can filter costs to the specific subscriptions and resource groups they need to report on.

How do I connect Azure analysis to Power BI? ›

Connect in Power BI Desktop
  1. In Power BI Desktop, click Get Data > Azure > Azure Analysis Services database.
  2. In Database, if you know the name of the tabular model database or perspective you want to connect to, paste it here. ...
  3. Select a connection option and then press Connect.
Oct 20, 2022

How do you use cost management in Azure? ›

To enable Cost Management in the Azure portal, you must have confirmed customer acceptance of the Microsoft Customer Agreement (on behalf of the customer) and transitioned the customer to the Azure Plan. Only the costs for subscriptions that are transitioned to the Azure plan are available in Cost Management.

What should you use to track costs of Azure resources? ›

Azure Cost Management + Billing is the primary tool you'll use to analyze your usage and costs. It gives you multiple options to analyze your monthly charges for different Azure Monitor features and their projected cost over time.

Which tool helps you estimate the cost you will include or Azure? ›

The Azure Pricing Calculator can help you understand the costs of moving workloads to the Azure cloud. It estimates Azure pricing once all your data and applications are in Azure.

How can you monitor the cost of the consumed Azure services? ›

Sign in to the Azure portal. Search for Cost Management + Billing. Depending on your access, you might need to select a Billing account or Billing profile.

What are the three types of cost analysis? ›

There are four main types of cost analysis: cost-feasibility, cost-effectiveness, cost-benefit (also referred to as benefit-cost), and cost-utility. Each type of analysis uses the same initial approach to assess resource costs but answers different questions.

What is Azure cost management tool? ›

Azure Cost Management lets you analyze past cloud usage and expenses, and predict future expenses. You can view costs in a daily, monthly, or annual trend, to identify trends and anomalies, and find opportunities for optimization and savings.

How do you perform a cost analysis? ›

Follow these six steps to help you perform a successful cost-based analysis.
  1. Step 1: Understand the cost of maintaining the status quo. ...
  2. Step 2: Identify costs. ...
  3. Step 3: Identify benefits. ...
  4. Step 4: Assign a monetary value to the costs and benefits. ...
  5. Step 5: Create a timeline for expected costs and revenue.

What are the 3 pricing models of Azure? ›

Currently, Azure offers three pricing models for VMs.
  • Pay-as-you-go. Pay-as-you-go is the simplest and most flexible payment model. ...
  • Reserved instances. This payment model saves money because it enables you to pay upfront for a predefined period of VM run time. ...
  • Spot VMs.
Aug 23, 2022

Where is cost management in Azure? ›

Cost Management is available from within the Billing experience. It's also available from every subscription, resource group, and management group in the Azure portal.

How do I enable cost management in Azure? ›

Enable access to costs in the Azure portal

To enable an option in the Azure portal: Sign in to the Azure portal at with an enterprise administrator account. Select the Cost Management + Billing menu item. Select Billing scopes to view a list of available billing scopes and billing accounts.

How is Microsoft Azure used for data analytics? ›

Azure Data Lake Analytics is an on-demand analytics job service that simplifies big data. Easily develop and run massively parallel data transformation and processing programs in U-SQL, R, Python, and . NET over petabytes of data.

How do I connect power apps to Azure? ›

Navigate to and sign-in.
  1. On the left menu, select Dataverse > Connections.
  2. Select + New connection.
  3. Search for Azure Data Explorer in the search bar. Select Azure Data Explorer from the resulting options.
  4. Select Create on the Azure Data Explorer popup. Provide credentials as required.
May 18, 2022

How do I access Azure Analysis Services? ›

In Azure portal > server > Overview > Server name, copy the server name. In SSMS > Object Explorer, click Connect > Analysis Services. Authentication type, Active Directory - Universal with MFA support, is recommended. If you sign in with a Microsoft Account, Live ID, Yahoo, Gmail, etc., leave the password field blank.

What are the four 4 main processes of cost management? ›

While cost management overall is a complicated process and a critical project management knowledge area, we can break it down into four processes:
  • Resource planning. ...
  • Cost estimation. ...
  • Cost budget. ...
  • Cost control.
Mar 18, 2022

What are the 5 functions of cost management? ›

Planning, communication, motivation, appraisal, and decision-making are the features that make managing costs an important business procedure. Resource allocation, cost estimation, cost budgeting, and cost control are the major functions of the cost management process.

What is an example of cost management? ›

A cost management plan example could be the budget for a home improvement project. Direct costs would include hired labor and building materials. Indirect costs would include equipment rental fees, insurance, and general maintenance.

What are the main factors that affect Azure cost? ›

Azure has data centers across the globe. Usage costs differ according to the location offering particular Azure services, products and resources—these costs factor in demand, popularity and local infrastructure costs.

What are the 3 important services offered by Azure? ›

This gives users the flexibility to use their preferred tools and technologies. In addition, Azure offers four different forms of cloud computing: infrastructure as a service (IaaS), platform as a service (PaaS), software as a service (SaaS) and serverless functions.

What are two pricing options for Azure services? ›

Azure offers a free tier, which provides free use of certain services for the first 12 months, and free forever usage of specific services. The majority of Azure services can be purchased under the “pay as you go” pricing model, which charges users based on actual usage.

How do I add Cost analysis to Azure dashboard? ›

Select "Group by" as "Resource group name" and then select the pin icon in the upper-right corner or just after the "<Subscription Name> | Cost analysis" and then pin to dashboard. Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Which Azure tools allows you to make detailed estimates for Azure deployment costs? ›

Azure total cost of ownership (TCO) calculator is a cost management tool that enables you to estimate the cost of migrating your workloads to Azure and predict your potential savings for existing workloads.

How do I create a cost alert in Azure? ›

  1. Prerequisites. Budgets are supported for the following types of Azure account types and scopes: ...
  2. Sign in to Azure. ...
  3. Create a budget in the Azure portal. ...
  4. Configure actual costs budget alerts. ...
  5. Configure forecasted budget alerts. ...
  6. Costs in budget evaluations. ...
  7. Trigger an action group. ...
  8. View budgets in the Azure mobile app.
Jan 3, 2023

Which of the following features are provided by Azure cost management? ›

  • Build and scale with managed Kubernetes.
  • Azure Container Apps. Build and deploy modern apps and microservices using serverless containers.
  • Easily deploy and run containerized web apps on Windows and Linux.
  • Store and manage container images across all types of deployments.
  • Azure Kubernetes Fleet Manager.

How do you integrate Power BI with an azure ad? ›

How to use the Azure AD Content Pack Preview
  1. Log into Power BI with your Power BI Account (same account as your O365 or Azure AD Account)
  2. Select Get Data at the bottom of the left navigation pane.
  3. In the Services box, select Get.
  4. Select Azure Active Directory Activity Logs > Get.

What does the Azure cost management tool do? ›

Azure Cost Analysis

Azure Cost Management's Cost Analysis tool helps you break down the details of your Azure spend—with this tool you can take a more in-depth look into exactly what everything costs, and do all kinds of grouping and filtering across your resources.

How do I add cost analysis to Azure dashboard? ›

Select "Group by" as "Resource group name" and then select the pin icon in the upper-right corner or just after the "<Subscription Name> | Cost analysis" and then pin to dashboard. Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

How do I connect my Azure AD to Powerapps? ›

Create a new app
  1. Open the Teams app.
  2. Select Power Apps.
  3. Select + New app under Recent apps.
  4. Select the team created earlier, and then select Create.
  5. The app gets created, and the Power Apps Studio opens to allow editing the app.
  6. Enter a name for the app, such as "Integrate with Azure AD", and then select Save.
Dec 15, 2022

What should you use to track the costs of Azure? ›

Azure Cost Management + Billing is the primary tool you'll use to analyze your usage and costs. It gives you multiple options to analyze your monthly charges for different Azure Monitor features and their projected cost over time.

How do you prepare a Cost analysis? ›

Follow these six steps to help you perform a successful cost-based analysis.
  1. Step 1: Understand the cost of maintaining the status quo. ...
  2. Step 2: Identify costs. ...
  3. Step 3: Identify benefits. ...
  4. Step 4: Assign a monetary value to the costs and benefits. ...
  5. Step 5: Create a timeline for expected costs and revenue.

How do you do cost value analysis? ›

Steps of a Cost-Benefit Analysis
  1. Establish a Framework for Your Analysis. ...
  2. Identify Your Costs and Benefits. ...
  3. Assign a Dollar Amount or Value to Each Cost and Benefit. ...
  4. Tally the Total Value of Benefits and Costs and Compare.
Sep 5, 2019


1. Analyze cost and create budgets with Azure Cost Management + Billing | LRN204
(Microsoft Ignite)
2. Azure Cost Management
(Cloud Lunch and Learn)
3. Azure Cost Management - Exports
(Hello World)
4. Analyze costs and create budgets with Azure Cost Management | LRN246
(Microsoft Ignite)
5. Explore your Azure costs with the Cost Analysis graph
(IT Ops Talk)
6. How to Analyze Spending in Power BI with Azure Consumption Insights | Power BI Training
Top Articles
Latest Posts
Article information

Author: Van Hayes

Last Updated: 03/16/2023

Views: 6156

Rating: 4.6 / 5 (66 voted)

Reviews: 89% of readers found this page helpful

Author information

Name: Van Hayes

Birthday: 1994-06-07

Address: 2004 Kling Rapid, New Destiny, MT 64658-2367

Phone: +512425013758

Job: National Farming Director

Hobby: Reading, Polo, Genealogy, amateur radio, Scouting, Stand-up comedy, Cryptography

Introduction: My name is Van Hayes, I am a thankful, friendly, smiling, calm, powerful, fine, enthusiastic person who loves writing and wants to share my knowledge and understanding with you.