Ta brskalnik ni več podprt.
Izvedite nadgradnjo na Microsoft Edge, če želite izkoristiti vse prednosti najnovejših funkcij, varnostnih posodobitev in tehnične podpore.
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. Power BI template apps aren't supported in Azure Government, Azure China 21 Vianet, and Azure Germany.
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 other data from other sources to create customized reports to get holistic views of your overall business cost. The connector also supports Microsoft Customer Agreements.
Opomba
Opomba
When you convert an EA enrollment to a Microsoft Customer Agreement (MCA), you can’t use the Cost Management Power BI template app any longer because the app doesn’t support MCA. However, the Azure Cost Management connector for Power BI Desktop supports MCA accounts.
To install the app:
On the Power BI AppSource page, select Get it now.
Select Continue to agree to the terms of use and privacy policy.
In the Install this Power BI app box, select Install.
If needed, create a workspace and select Continue.
When installation completes, notification appears saying that your new app is ready.
Select the app that you installed.
On the Getting started page, select Connect your data.
In the dialog that appears, enter your EA enrollment number for BillingProfileIdOrEnrollmentNumber. Specify the number of months of data to get. Enter "Enrollment Number" for Scope, then select Next.
The next installation step connects to your EA enrollment and requires an Enterprise Administrator account. Leave all the default values. Select Sign in and continue.
The final dialog connects to Azure and gets data. Leave the default values as configured and select Sign in and connect.
You're prompted to authenticate with your EA enrollment. Authenticate with Power BI. After you're authenticated, a Power BI data gets refreshed.
Opomba
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 precreated reports.
The following reports are available in the app.
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:
Opomba
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 based on the date selection.
Here's how values in the overview tiles are calculated.
adjustments.ServiceOverage.chargesBilledseparately.azureMarketplaceServiceCharges.newPurchases.adjustments + ServiceOverage + chargesBilledseparately + azureMarketplaceServiceCharges).The Power BI template app includes Adjustments, Service Overage, Charges billed separately, and Azure Marketplace service charges as 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.
The report also identifies Windows VMs where Hybrid Benefit is enabled but there are fewer 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. To maximize your potential savings, apply the benefit to your most expensive virtual machines.
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:
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 virtual machine (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 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.
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.
If you're having issues with the Power BI app, the following troubleshooting information might help.
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. Don't enter your organization's enrollment number, instead type Enrollment Number exactly as it appears in the following image.
You might get an error stating:
Something went wrong
There 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.
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.
The following information summarizes the data available through the app.
| Table reference | Description |
|---|---|
| AutoFitComboMeter | Data included in the app to normalize the RI recommendation and usage to the smallest size in the instance family group. |
| Balance summary | Summary of the balance for Enterprise Agreements. |
| Budgets | Budget details to view actual costs or usage against existing budget targets. |
| Pricesheets | Applicable meter rates for the provided billing profile or EA enrollment. |
| RI charges | Charges 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 seven days. |
| RI recommendations (single) | Reserved instance purchase recommendations based on your single subscription usage trends for the last seven days. |
| RI usage details | Consumption details for your existing reserved instances over the last month. |
| RI usage summary | Daily Azure reservation usage percentage. |
| Usage details | A breakdown of consumed quantities and estimated charges for the given billing profile in the EA enrollment. |
| Usage details amortized | A breakdown of consumed quantities and estimated amortized charges for the given billing profile in the EA enrollment. |
For more information about configuring data, refresh, sharing reports, and other report customization see the following articles:
Usposabljanje
Modul
Optimize Azure costs with data analysis in Power BI - Training
Use Power BI to understand where your money is being spent in Azure so you can help your organization to optimize its costs.
Potrdilo
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.
Dokumentacija
Connect to Microsoft Cost Management data in Power BI Desktop. - Power BI
Easily connect to Azure and gain insights about your Azure cost and usage with Power BI Desktop
Azure Cost Management connector - Power Query
Includes basic information, prerequisites, and information on how to connect to Azure Cost Management.
Get started with Cost Management reporting - Azure - Microsoft Cost Management
This article helps you to get started with Cost Management to understand, report on, and analyze your invoiced Microsoft Cloud and AWS costs.