November 2024 (v0.7)

🆕 New in November 2024

• 📗 Implementing FinOps guide added enterprise app patterns.
• 🏦 FinOps hubs added support for Azure Data Explorer, private endpoints, storage account infrastructure encryption, and FOCUS 1.0r2. Data Explorer is recommended for high-performance advanced analytics when monitoring over $1M in total cost.
• 📊 Power BI reports are now split into separate storage and KQL versions to support FinOps hubs with Data Explorer. Storage reports added partial support for OneLake URLs.

  NOTE: Power BI downloads have been renamed. Please use:

  • PowerBI-storage.zip for templates that connect to storage (with or without FinOps hubs)
  • PowerBI-kql.zip for templates that connect to FinOps hubs with Data Explorer
  • PowerBI-demo.zip for reports with sample data

ℹ️ Updated

• 📗 Implementing FinOps guide updated FOCUS conversion instructions.
• 📊 Power BI reports had various small fixes and improvements across all reports.
• 🏦 FinOps hubs changed the structure of ingested data to support ingestion into Azure Data Explorer, as well as various small fixes and improvements.
• 📒 FinOps workbooks had various small fixes and improvements.
• 🔍 Azure Optimization Engine had various small fixes and improvements.
• 🌐 Open data files were all updated.

🚨 Breaking changes

• FinOps hubs 0.7 changes the storage path data gets written to in the ingestion container.
  • What changed?
    • 0.6 path: {export-dataset}/yyyy/MM/{scope}
    • 0.7 path: {hub-dataset}/yyyy/MM/{scope}
    • Dataset mapping:
      • focuscost → Costs
      • pricesheet → Prices
      • reservationdetails → CommitmentDiscountUsage
      • reservationrecommendations → Recommendations
      • reservationtransactions → Transactions
  • Why is it changing?
    • Necessary to support ingesting different export datasets into the same Data Explorer table.
    • Aligns to table names in Azure Data Explorer.
  • Do I need to re-backfill historical data?
    • If using storage-based reports, no. 0.7 reports will work with existing exports from FinOps hubs 0.2 or later.
    • If using Data Explorer, yes.
  • What about customized reports?
    • Customized reports from 0.6 or earlier will not work with FinOps hubs 0.7 due to the storage path change.
    • To update custom reports, use the advanced editor to copy the ftk_Storage function from 0.7 into your custom report.
    • If you changed the queries, start a discussion to share what you're trying to accomplish so we can attempt to find a way for you to make those changes without being impacted by query updates.

Thanks to @elbarnit, @ro100e, @juyamagu, @nteyan, @MSBrett, @helderpinto, @arthurclares, and @flanakin for their contributions!

Thanks to @aromano2, @akiskips, @jamelachahbar, @Zeo-shark, @saadmsft, @KevDLR, @akiskips, @didayal-msft, @Springstone, @SCuffy, @CaddyG, and @chris-bowman for their support!

---

📣 Blog       💬 Discuss       📜 Changelog       🖥️ PowerShell       ℹ️ About       📗 Docs       ❤️ Give feedback

September 2024 (v0.6)

🆕 New in September 2024

• 📗 Implementing FinOps guide introduced a new FinOps best practices library.
• 📊 Power BI reports expanded to include new Governance and Workload optimization reports, and the cost data now includes a customizable set of tags promoted as columns to simplify tag extraction.
• 🏦 FinOps hubs added support for all Cost Management datasets and parquet and GZip CSV support. All datasets are normalized to FOCUS conventions.
• 📒 FinOps workbooks have been packaged together into a single deployment template to deploy both workbooks together.
• 🔍 Azure Optimization Engine replaced storage account key-based auth with Entra ID auth and added a troubleshooting guide.
• 🌐 Open data files adds support for the FOCUS 1.1 ServiceSubcategory column in the Services mapping file.

ℹ️ Updated

• 🏦 FinOps hubs changed the structure of ingested data to support streamlined data queries and future support for ingestion into other systems, as well as various small fixes and improvements.
• 📊 Power BI reports had various small fixes and improvements across all reports.
• 🔍 Azure Optimization Engine improved SQL database security and various other small fixes and improvements.
• 🌐 Open data files were all updated.

🚨 Breaking changes

• FinOps hubs 0.6 changes the storage path data gets written to in the ingestion container.
  • What changed?
    • 0.5 path: {scope}/yyyyMM/focuscost
    • 0.6 path: {dataset}/yyyy/MM/{scope}
  • Why is it changing?
    • Improves performance of Power BI queries.
    • Necessary to clearly differentiate between different datasets.
    • Unblocks streamlined ingestion into other systems (e.g., Azure Data Explorer, Microsoft Fabric).
  • Do I need to re-backfill historical data?
    • No. 0.6 Power BI reports will work with existing exports from FinOps hubs 0.2 or later.
  • What about customized reports?
    • Customized reports from 0.5 or earlier will not work with FinOps hubs 0.6 due to the storage path change.
    • To update custom reports, use the advanced editor to copy each query from 0.6 into your custom report.
    • If you changed the queries, start a discussion to share what you're trying to accomplish so we can attempt to find a way for you to make those changes without being impacted by query updates.

Thanks to @aromano2, @akiskips, @nteyan, @jamelachahbar, @Zeo-shark, @ro100e, @MSBrett, @helderpinto, @arthurclares, and @flanakin for their contributions!

Thanks to @saadmsft, @KevDLR, @akiskips, @didayal-msft, @Springstone, @SCuffy, @CaddyG, @sebassem, and @chris-bowman for their support!

---

💬 Discuss       📜 Changelog       🖥️ PowerShell       📗 Learn more       ❤️ Give feedback

August 2024 (v0.5)

🆕 New in August 2024

• 📗 Implementing FinOps guide has a new doc to compare FOCUS and actual/amortized datasets.
• 📊 Power BI reports now support raw Cost Management exports and removed the dependency on the Cost Management connector.
• 📒 Cost optimization workbook includes new and updated queries.
• 🔍 Azure Optimization Engine added a new Register-MultitenantAutomationSchedules script, ZRS disks for underutilized disk recommendations, and an option to scope exports to MCA billing profiles.

ℹ️ Updated

• 🏦 FinOps hubs had various small fixes and improvements.
• 📊 Power BI reports had various small fixes and improvements across all reports.
• 📒 Governance workbook improved the subscription filtering experience.
• 🔍 Azure Optimization Engine improved SQL database security and various other small fixes and improvements.
• 🖥️ FinOps toolkit PowerShell commands had various small fixes and improvements to export and FinOps hub management commands.
• 🌐 Open data files were all updated.

Thanks to @helderpinto, @nteyan, @MSBrett, @ro100e, @aromano2, @Misba-Yousuf, @arthurclares, and @flanakin for their contributions!

Thanks to @didayal-msft, @sebassem, @SCuffy, @chris-bowman, @CaddyG, @jamelachahbar, @thecloudman, and @Springstone for their support!

---

💬 Discuss       📜 Changelog       🖥️ PowerShell       📗 Learn more       ❤️ Give feedback

July 2024 (v0.4)

🆕 New in July 2024

• 🔍 Azure Optimization Engine – An extensible solution for custom optimization recommendations.
• 📗 Implementing FinOps guide updated to FinOps Framework 2024 and FOCUS 1.0.
• 🏦 FinOps hubs support for FOCUS 1.0, managed exports, and cross-tenant exports.
• 📊 Power BI reports were all updated to FOCUS 1.0.

ℹ️ Updated

• 📊 Power BI reports had various small fixes and improvements across all reports.
• 📒 Cost optimization workbook updated to include the latest changes from Azure Advisor.
• 📒 Governance workbook had a few minor updates.
• 🖥️ FinOps toolkit PowerShell commands were updated to support FOCUS 1.0 exports.
• 🌐 Open data files were all updated.

Thanks to @helderpinto, @MSBrett, @didayal-msft, @nteyan, @ripadrao, @arthurclares, and @flanakin for their contributions!

Thanks to @sebassem, @SCuffy, @chris-bowman, @CaddyG, @jamelachahbar, @thecloudman, and @Springstone for their support!

---

💬 Discuss       📜 Changelog       🖥️ PowerShell       📗 Learn more       ❤️ Give feedback

March 2024 (v0.3)

🆕 New in March 2024

• 📗 FinOps documentation and other learning resources have been added.
• 📊 Power BI reports have all been updated and a new Data ingestion report was added to provide insights into storage.
• 📒 Cost optimization workbook now respects the global subscription filter.
• 🖥️ FinOps toolkit PowerShell commands to backfill Cost Management exports.
• 🌐 Open data files for Services now includes ServiceModel and Environment columns.

ℹ️ Updated

• 🏦 FinOps hubs bug fixes and improvements.
• 📊 Power BI reports had many fixes and improvements across all reports!
• 📒 Governance workbook improvements for manage disks, combined governance and security tabs, and enabled the export button.
• 🖥️ FinOps toolkit PowerShell commands fixes to adapt to Cost Management API changes.

Thanks to @arthurclares, @ymehdimsft, @sebassem, @msamendinger, @psilantropy, @patkje75, @erincon01, @yuanzhang9, and @flanakin for their contributions!

Thanks to @ripadrao, @MSBrett, @chris-bowman, @BenShy, @helderpinto, @jamelachahbar, @thecloudman, @rodneyjoyce, @elvismangarae, @NavidKhan8, @maikvandergaag, @mutansee, @aromano2, and @Springstone for their support!

---

💬 Discuss       📜 Changelog       🖥️ PowerShell       📗 Learn more       ❤️ Give feedback

January 2024 (v0.2)

🆕 New in January 2024

• 🏦 FinOps hubs support for China and the FinOps Open Cost and Usage Specification (FOCUS).

  ⚠️ There is a bug in the FinOps hubs template. Please use the 0.2.1 release candidate. The new release will be published soon.

• 📊 Power BI reports now support FOCUS and include a new report for the Cost Management connector.
• 📒 Cost optimization workbook:
  • Storage: Identify idle backups and review replication settings.
  • Networking: Azure Firewall optimization checks.
• 🖥️ FinOps toolkit PowerShell commands to create and run Cost Management exports, including support for FOCUS, price sheet, reservation details, reservation transactions, and reservation recommendations exports
• 🌐 Open data files for resource types (with friendly display names and icons) and sample exports to demonstrate cost, price, and reservation datasets.

ℹ️ Updated

• 🏦 FinOps hubs bug fixes and improvements.
• 📊 Power BI reports:
  • Fixed dynamic data source error when the Power BI service refreshes data.
  • Improved loading performance and reduced memory consumption.
  • Various bug fixes and improvements.
• 📒 Cost optimization workbook:
  • Top 10 services: Updated recommendations for Log Analytics.
  • AHB: Fixed AHB to support Windows 10/11.
• 🖥️ FinOps toolkit PowerShell commands updated to fix a failure in Deploy-FinOpsHub and get run history with Get-FinOpsCostExport.

🚨 Breaking changes

• FinOps hubs 0.2 requires new exports and new reports.
  • New FOCUS exports must be created and new 0.2 reports must be used to connect to the hub instance.
  • Previous actual and amortized cost exports will not work with hubs 0.2 or with 0.2 reports
  • Actual and amortized cost exports should be stopped, deleted, or redirected to a different container.
  • Existing data can remain in storage but will be ignored by the 0.2 reports. Please use 0.1.x reports to view actual/amortized data.
• Power BI reports in 0.2 only work with FinOps hubs 0.2.
  • 0.2 reports will not work with a 0.1.x hub instance or connect to old actual/amortized cost exports.
  • 0.1.x reports will not work with a 0.2 hub instance or connect to new FOCUS cost exports.
  • The connector report is independent and not impacted.

Note

Templates are not yet available in the Azure Quickstart Templates repository yet. Please see downloads below!

Thanks to @arjenhuitema, @yuanzhang9, @sebassem, @arthurclares, and @flanakin for their contributions!

Thanks to @MSBrett, @chris-bowman, @BenShy, @helderpinto, @jamelachahbar, @thecloudman, @rodneyjoyce, @elvismangarae, @erincon01, @NavidKhan8, @maikvandergaag, @mutansee, @aromano2, @Springstone, @saadmsft, @didayal-msft, and @ijurica for their support!

---

💬 Discuss       📜 Changelog       🖥️ PowerShell       📗 Learn more       ❤️ Give feedback

October 2023 Update 1 (v0.1.1)

🆕 New in 0.1.1

• 🖥️ FinOps toolkit PowerShell commands:
  • Convert cost data to the FinOps Open Cost and Usage Specification (FOCUS).
  • Get and delete Cost Management exports
  • Get open data sets for pricing units, regions, and services.
  • Get and delete FinOps hubs.

ℹ️ Updated

• 📒 Cost optimization workbook updated to cover more scenarios.

Thanks to @jamelachahbar, @aromano2, @Springstone, @saadmsft, @arjenhuitema, @didayal-msft, @sebassem, @arthurclares, and @flanakin for their contributions!

Thanks to @MSBrett, @nteyan, @soumyananda, @lkshck, @helderpinto, @AdamAndersson, @ijurica, @arthurclares, @Springstone, @saadmsft, @didayal-msft, @jamelachahbar, and @slavikn84 for their support!

---

💬 Discuss       📜 Changelog       📦 Templates       📗 Learn more

October 2023 (v0.1)

🆕 New in 0.1

• 📊 Power BI reports covering both the Cost Management connector and FinOps hubs!
  • Cost summary and Commitment discounts from the 0.0.1 release have been expanded to support the CM connector.
  • Added new pages for prices, commitments, savings, chargeback, and purchases in the Commitment discounts report.
  • Added a new FOCUS sample report to demonstrate FOCUS 0.5, including the latest changes for FOCUS 1.0.
  • Added a PBIX download for the Cost Management template app for Enterprise Agreement accounts.
• 🖥️ FinOps toolkit PowerShell commands to deploy FinOps hubs. (More coming soon!)
• 📒 Governance workbook covering CAF/WAF governance guidance.
• 🌐 Open data files with pricing units, regions, and services for data cleansing.

ℹ️ Updated

• 🏦 FinOps hubs bug fixes and support for MCA.
• 📒 Cost optimization workbook updated to cover more scenarios.

Note

Templates are not yet available in the Azure Quickstart Templates repository yet. Please see downloads below!

Thanks to @MSBrett, @aromano2, @nteyan, @sebassem, @soumyananda, and @flanakin for their contributions!

Thanks to @lkshck, @helderpinto, @AdamAndersson, @ijurica, @arthurclares, @Springstone, @saadmsft, @didayal-msft, @jamelachahbar, and @slavikn84 for their support!

---

💬 Discuss       📜 Changelog       📗 Learn more

May 2023 (v0.0.1)

This release includes the first versions of the finops-hub and optimization-workbook templates. Both templates are available from the Azure Quickstart Templates repository.

Thanks to @MSBrett, @aromano2, @arthurclares, @sebassem, and @flanakin for their contributions!

---

Update 1 (Jun 27, 2023)

Added CostSummary.pbix and CommitmentDiscounts.pbix reports for download. Both reports include sample data for local testing without connecting your data. CostSummary.pbix includes a FOCUS sample page.

---

💬 Discuss       📜 Read changelog       📦 View templates       📗 Learn more

April 2023 (v0.0.1-alpha)

This is an early alpha release for internal testing purposes only. This release is not ready for production use. If you have questions or comments, please join us in the v0.0.1 discussion thread.