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

[arthursilvany]

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

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]

[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 GitHub<#449 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AHPFGCZ36JJIUJYCMN32D7LYHWMFPAVCNFSM6AAAAAA67QRXLKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMZYGE4DOMZWHA>. You are receiving this because you authored the thread.Message ID: ***@***.***>