How to get all the billing data for a subscription in Azure on to Excel

Ronit 0 Reputation points
2023-05-31T18:51:59.58+00:00

I want to get All the billing data for one of my Azure subscriptions, and download that data as a excel file.

I know that I can go to "Cost Management + Billing" and download all of cost and billing data, from there.

But I cant seem to find the data I need. I did it once a month ago but can't do it again.

I want the billing data for the entire subscription, not just some resource or group of the subscription.

my previous excel file had the following rows: "InvoiceSectionName AccountName AccountOwnerId SubscriptionId SubscriptionName ResourceGroup ResourceLocation Date ProductName MeterCategory MeterSubCategory MeterId MeterName MeterRegion UnitOfMeasure Quantity EffectivePrice CostInBillingCurrency CostCenter ConsumedService ResourceId Tags OfferId AdditionalInfo ServiceInfo1 ServiceInfo2 ResourceName ReservationId ReservationName UnitPrice ProductOrderId ProductOrderName Term PublisherType PublisherName ChargeType Frequency PricingModel AvailabilityZone BillingAccountId BillingAccountName BillingCurrencyCode BillingPeriodStartDate BillingPeriodEndDate BillingProfileId BillingProfileName InvoiceSectionId IsAzureCreditEligible PartNumber PayGPrice PlanName ServiceFamily CostAllocationRuleName benefitId benefitName"

I again need something with all these rows or headers

Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,029 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,457 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,639 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. SadiqhAhmed-MSFT 37,536 Reputation points Microsoft Employee
    2023-05-31T19:28:05.9033333+00:00

    Hello @Ronit Thank you for contacting us on Microsoft Q&A platform. Happy to help!

    I understand that you want to download your Azure subscription billing data into an excel file.

    I have previously answered couple of questions and hoping that it will help you accomplish your requirements.

    https://learn.microsoft.com/en-us/answers/questions/1135104/how-long-can-we-go-back-to-query-the-cost-usage-us

    https://learn.microsoft.com/en-us/answers/questions/744528/azure-consumption-api-for-past-months#answer-956899

    If you are planning to query the cost at management group scope, here are the suggestions to follow - https://learn.microsoft.com/en-us/answers/questions/854150/how-to-fetch-management-group-cost-by-using-azure

    Hope this helps!

    0 comments