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

Question

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

Answer 1

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!