Azure cost management data - retrieve data for specific 12 month period

[Richardblack]

Hi, I have created my own dashboards for Azure Cost Management which show specific summaries for my senior management. However, now that the dashboards have been upmfor more than a year, I have realised that the data is only the last 12 months. What i want to do is split the data into financial years and have previous years data fixed (so no refreshing the data once its loaded). However, i can't find a way to do this. The date range parameter in the connector will only take a range of 31 days. I know the data must still exists, as i can still see the analysis in the native azure cost analysis tool. Does anyone know how to access historic data?

[Anonymous]

Hi @Richardblack ,
Based on your description, first the summary data in the cost analysis only applies to the last 13 months. If you use the export option in the configuration subscription, then you can export up to 90 days of historical costs from the selected day. If you want to export data for longer dates you can use the export Api, but you need to be aware that the export Api also exports up to three months. So, you can set the TimeframeType to custom and set the ExportTime Period date range of the data in the export. This value should only be specified if timeFrame is set to “Custom”. The maximum date range is 3 months. Repeat four times to pull 13 months of data.

Tutorial - Create and manage exported data from Cost Management - Microsoft Cost Management | Micros...
Understand Cost Management data - Microsoft Cost Management | Microsoft Learn
Exports - Create Or Update - REST API (Azure Cost Management) | Microsoft Learn

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Richardblack]

Hi Albert, I'm using the native Azure Cost Management connector in Power BI desktop. I am assuming that you mean I need to use the API to generate these exports instead? I'm afraid I'm quite new to this so I'm not sure *where* I'd put the code to do the exports. Apologies if this obvious!

Richard