Releases: microsoft/finops-toolkit
February 2025 (v0.8)
🆕 New in February 2025
- 📗 Implementing FinOps guide added enterprise app patterns.
- 📊 Power BI reports have a new design and a new Rate optimization Total savings page with Effective Savings Rate (ESR). KQL reports had a major performance update and storage reports have a new option to populate missing prices/costs (KQL reports have this built in).
- 🏦 FinOps hubs added a new Azure Data Explorer dashboard, new monthstring() and datestring() KQL functions, and removed network components when public access is selected.
- 📒 FinOps workbooks added Azure Arc Windows license management in the Cost optimization workbook.
- 🖥️ FinOps toolkit PowerShell commands added new options to Cost Management export commands.
ℹ️ Updated
- 📗 Implementing FinOps guide updated to include the Learning FOCUS blog series on the FOCUS overview.
- 📊 Power BI reports had various small fixes and improvements across all reports.
- 🏦 FinOps hubs changed Data Explorer to default to block access from external tenants, updated the
numberstring()
KQL function to support more scenarios, and applied various small fixes and improvements. - 📒 FinOps workbooks had various small fixes and improvements.
- 🔍 Azure Optimization Engine improved Azure Lighthouse guidance for multi-tenancy support.
- 🖥️ FinOps toolkit PowerShell commands had various small fixes and improvements to Cost Management export commands.
- 🌐 Open data files were all updated.
Thanks to @RolandKrummenacher, @JayAreP, @ro100e, @MSBrett, @helderpinto, @arthurclares, and @flanakin for their contributions!
Thanks to @aromano2, @akiskips, @jamelachahbar, @Zeo-shark, @saadmsft, @KevDLR, @didayal-msft, @Springstone, @SCuffy, @CaddyG, and @chris-bowman for their support!
📜 Changelog 🖥️ PowerShell ℹ️ About 📗 Docs ❤️ Give feedback
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
- 0.6 path:
- 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.
- What changed?
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}
- 0.5 path:
- 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.
- What changed?
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.