search

microsoft / finops-toolkit

Tools and resources to help you adopt and implement FinOps capabilities that automate and extend the Microsoft Cloud.
https://aka.ms/finops/toolkit
MIT License
237 stars 77 forks source link

[Hubs] Create a method for adding cost management databeyond 90 days #449

Open arthursilvany opened 8 months ago

arthursilvany commented 8 months ago

📝 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.

flanakin commented 7 months ago

FYI - This will come with FinOps hubs ~0.2~ 0.3 with managed exports. It's mostly done already. The one thing I believe we're missing is kicking off the backfill process.

Update: We ended up shipping a FOCUS release before the one with managed exports and backfill support. This is in progress.

arthursilvany commented 7 months ago

[heart] Arthur Silvany (HE/HIM) reacted to your message:

From: Michael Flanakin @.> Sent: Monday, December 4, 2023 9:50:15 AM To: microsoft/finops-toolkit @.> Cc: Arthur Silvany (HE/HIM) @.>; Author @.> Subject: Re: [microsoft/finops-toolkit] Create a method for adding cost management databeyond 90 days (Issue #449)

FYI - This will come with FinOps hubs 0.2. It's mostly done already. The one thing I believe we're missing is kicking off the backfill process.

— Reply to this email directly, view it on GitHubhttps://github.com/microsoft/finops-toolkit/issues/449#issuecomment-1838187368, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AHPFGCZ36JJIUJYCMN32D7LYHWMFPAVCNFSM6AAAAAA67QRXLKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMZYGE4DOMZWHA. You are receiving this because you authored the thread.Message ID: @.***>