microsoft / microsoft/finops-toolkit
[Hubs] Create a method for adding cost management databeyond 90 days
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 603
- Forks
- 248
- Avg merge
- 7d 11h
- Merged PRs (30d)
- 11
Description
📝 Scenario
Azure Cost Export has a limitation of collecting cost management data for up to 90 days in the past. Many customers need data for up to 1 year, and this can only be done through the API. As a possible workaround, I used the Power BI cost management connector and saved it as a CSV using DAX Studio. Then, I uploaded the CSV file to the msexport container, and Data Factory was able to collect it. However, I can't see the files for the other months in Power BI.
💎 Solution
Create a solution that allows analyzing cost management data beyond 90 days using the API or DAX Studio.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reviewing the Azure Cost Export 90-day limitation and how the msexport container and Data Factory currently collect CSV data. Compare an API-based approach with the Power BI cost management connector or DAX Studio, then define how files for all requested months should become available for analysis.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- azure
- Domain
- analytics, cloud, data
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100