Delen via

Choose a cost details solution

There are multiple ways to work with the cost details dataset (formerly referred to as usage details). If your organization has a large Azure presence across many resources or subscriptions, you might have a large amount of cost details data. Excel kan vaak niet zulke grote bestanden laden. In this situation, we recommend the following options.

Exports

Exports are recurring data dumps to storage that can be configured to run on a custom schedule. We recommend Exports as the solution to ingest cost details data. It's the most scalable for large enterprises. Exports are configured in the Azure portal or using the Exports API. Review the following considerations to analyze whether this solution is best for your particular data ingestion workload.

  • Exports are most scalable solution for your workloads.
  • Can be configured to use file partitioning for bigger datasets.
  • Great for establishing and growing a cost dataset that can be integrated with your own queryable data stores.
  • Requires access to a storage account that can hold the data.

To learn more about how to properly call the API and ingest cost details at scale, see Retrieve large datasets with exports.

Cost Details API

The Cost Details API is the go to solution for on demand download of the cost details dataset. Review the following considerations to analyze whether this solution is best for your particular data ingestion workload.

  • Useful for small cost datasets. Exports scale better than the API. The API might not be a good solution if you need to ingest many gigabytes worth of cost data month over month. A GB of cost details data is roughly 1 million rows of data.
  • Useful for scenarios when Exports to Azure storage aren't feasible due to security or manageability concerns.

If the Cost Details API is your chosen solution, review the best practices to call the following API.

  • Als u de meest recente kostengegevens wilt ophalen, raden we u aan om maximaal één keer per dag een query uit te voeren. Rapporten worden elke vier uur vernieuwd. Als u vaker belt, ontvangt u identieke gegevens.
  • Zodra u uw kostengegevens voor historische facturen hebt gedownload, worden de kosten niet gewijzigd, tenzij u expliciet op de hoogte wordt gesteld. We raden u aan uw kostengegevens in een querybare opslag op te slaan om herhaalde aanroepen voor identieke gegevens te voorkomen.
  • Deel uw aanroepen in kleine datumbereiken om meer beheerbare bestanden te krijgen die u kunt downloaden. We raden u bijvoorbeeld aan te segmenteren op dag of per week als u grote Azure-gebruiksbestanden maandelijks hebt.
  • Als u bereiken hebt met een grote hoeveelheid gebruiksgegevens (bijvoorbeeld een factureringsaccount), kunt u overwegen om meerdere aanroepen naar onderliggende bereiken te plaatsen, zodat u meer beheerbare bestanden krijgt die u kunt downloaden.
  • If you get bound by rate limits at a lower scope, consider calling a higher scope to download data.
  • Als uw gegevensset meer dan 2 GB per maand is, kunt u overwegen om exports te gebruiken als een schaalbare oplossing.

To learn more about how to properly call the Cost Details API, see Get small usage data sets on demand.

The Cost Details API is only available for customers with an Enterprise Agreement or Microsoft Customer Agreement. If you're a pay-as-you-go or Visual Studio customer, see Get usage details for pay-as-you-go subscriptions.

Power BI

Power BI is another solution that you can use to work with cost details data. The following Power BI solutions are available:

  • Cost Management Template App: - If you're an Enterprise Agreement or Microsoft Customer Agreement customer, you can use the Power BI template app to analyze costs for your billing account. It includes predefined reports that are built on top of the cost details dataset, among others. Kijk voor meer informatie naar Azure-kosten analyseren met de Power BI-sjabloon-app.
  • Cost Management Connector: - If you want to analyze your data daily, you can use the Power BI data connector to get data for detailed analysis. Any reports that you create are kept up to date with the connector as more costs accrue.

Azure portal download

Only download your usage from the Azure portal if you have a small cost details dataset that is capable of being loaded in Excel. Cost files that are larger than one or 2 GB might take an exceedingly long time to generate on demand from the Azure portal. They take longer to transfer over a network to your local computer. We recommend using one of the above solutions if you have a large monthly usage dataset.

Verwante inhoud