FinOps toolkit changelog Explore the latest and greatest features and enhancements from the FinOps toolkit.

Download the latest release See changes

On this page

🔄️ Unreleased

🏦 FinOps hubs

➕ Added:

  1. Managed exports – Let FinOps hubs manage exports for you.
  2. Auto-backfill – Backfill historical data from Microsoft Cost Management.
  3. Remote hubs – Ingest cost data from other tenants.
  4. Retention – Configure how long you want to keep Cost Management exports and normalized data in storage.
  5. Analytics engine – Ingest cost data into an Azure Data Explorer cluster.


🚚 v0.3

📗 FinOps documentation

➕ Added:

  1. Added the FinOps documentation to provide guidance around how to implement and adopt FinOps in the Microsoft Cloud.

🏦 FinOps hubs

➕ Added:

  1. Started archiving template versions so they can be referenced easily via URL microsoft.github.io/finops-toolkit/deploy/finops-hub-{version}.json.

🛠️ Fixed:

  1. Fixed “missing period” error Data Factory Studio.
  2. Fixed bug where msexports_FileAdded trigger was not getting started.
  3. Fixed deploy to Azure buttons to point to the latest release.

✏️ Changed:

  1. Return a single boolean value from the Remove-FinOpsHub command.

📊 Power BI reports

➕ Added:

  1. Added a DQ page to the Commitment discounts report for data quality validations. This page can be useful in identifying data gaps in Cost Management.
  2. Added x_NegotiatedUnitPriceSavings column to show the price reduction from negotiated discounts compared to the public, list price.
  3. Added x_IsFree column to indicate when a row represents a free charge (based on Cost Management data). This is used in data quality checks.
  4. Added Tags and TagsAsJson columns to both the Usage details and Usage details amortized tables in the CostManagementTemplateApp report (#625).

🛠️ Fixed:

  1. Fixed numerous errors causing the Cost Management connector report to not load for MCA accounts.
  2. Fixed incorrect filter in the Commitment discounts report (#585).
  3. Fixed data issue where Cost Management uses “1Year”, “3Years”, and “5Years” for the x_SkuTerm. Values should be 12, 36, and 60 (#594).
  4. Changed the data type for the x_Month column to be a date.
  5. Changed x_SkuTerm to be a whole number and to not summarize by default.
  6. Changed x_BillingExchangeRate to not summarize by default.
  7. Corrected references to x_InvoiceIssuerId and InvoiceIssuerName columns in the Cost Management connector report (#639).

✏️ Changed:

  1. Changed “Other” ChargeSubcategory for usage to “On-Demand” to be consistent with Cost Management exports
  2. Renamed savings columns for consistency:
    • x_OnDemandUnitPriceSavings is now x_CommitmentUnitPriceSavings. This shows the commitment discount price reduction compared to the negotiated prices for the account.
    • x_ListUnitPriceSavings is now x_DiscountUnitPriceSavings. This shows the price reduction from all discounts compared to the public, list price.
    • x_NegotiatedSavings is now x_NegotiatedCostSavings. This shows the cost savings from negotiated discounts only (excluding commitment discounts).
    • x_CommitmentSavings is now x_CommitmentCostSavings. This shows the cost savings from commitment discounts compared to on-demand prices for the account (including negotiated discounts).
    • x_DiscountSavings is now x_DiscountCostSavings. This shows the cost savings from all negotiated and commitment discounts.
  3. Changed the PricingQuantity and UsageQuantity columns to use 3 decimal places.
  4. Changed all cost columns to use 2 decimal places.
  5. Changed all unit price columns to not summarize by default and use 3 decimal places.
  6. Changed the x_PricingBlockSize column to a whole number and not summarize by default.
  7. Renamed the Coverage pages in the Commitment discounts report to Recommendations.

📒 Azure Monitor workbooks

➕ Added:

  1. Started archiving template versions so they can be referenced easily via URL microsoft.github.io/finops-toolkit/deploy/{template}-{version}.json.

✏️ Changed:

  • Governance workbook:
    1. Managed disk visual improvement.
    2. Removed blueprints (replaced by deployment stacks and template specs).
    3. Combined the Governance and Security tabs.
    4. Enabled the export button.

🛠️ Fixed:

  1. Fixed deploy to Azure buttons to point to the latest release.
  • Optimization workbook:
    1. Fixed a typo with Azure Hybrid benefits query.
    2. Fixed a bug with the SQL Managed Instance query where the query had a merge error.

🖥️ PowerShell

➕ Added:

  1. Get-FinOpsCostService includes new -Environment and -ServiceModel filters and properties in the response (#585).

✏️ Changed:

  1. Start-FinOpsCostExport includes a new -Backfill option to backfill multiple months.
  2. Start-FinOpsCostExport includes a new -StartDate and -EndDate options to run the export for a given date range. This can include multiple months.

🛠️ Fixed:

  1. Fixed ParameterBindingException error in New-FinOpsCostExport.
  2. Updated the FOCUS dataset version that was changed in Cost Management exports in New-FinOpsCostExport.
  3. Changed the default -EndDate in New-FinOpsCostExport to be the end of the month due to a breaking change in Cost Management exports.
  4. Fixed internal command used in Deploy-FinOpsHub that may have caused it to fail for some versions of the Az PowerShell module.

🌐 Open data

➕ Added:

  1. Added ServiceModel and Environment columns to the services data (#585).
  2. New and updated resource types and icons.

Download v0.3 Full changelog

📊 Power BI reports

➕ Added:

  1. ResourceParentId, ResourceParentName, and ResourceParentType columns to support the usage of the user-defined cm-resource-parent tag.
  2. ToolkitVersion and ToolkitTool columns to help quantify the cost of FinOps toolkit solutions.

🛠️ Fixed:

  1. Corrected the datatype for the x_Month column.

📗 FinOps guide

➕ Added:

  1. Move Azure FinOps documentation into the toolkit.

✏️ Changed:

  1. Rearranged documentation site to better organize content.


🚚 v0.2

🏦 FinOps hubs

Breaking change

🛠️ Fixed:

  1. Fixed error in some China regions where deployment scripts were not supported (#259).

✏️ Changed:

  1. Switch from amortized cost exports to FOCUS cost exports.

    This change requires re-ingesting historical data and is not backwards compatible. The unified schema used in this release is aligned with the future plans for Microsoft Cost Management exports. Note the next release will update the schema to align to the FinOps Open Cost and Usage Specification (FOCUS).

  2. Updated ingestion container month folders from yyyyMMdd-yyyyMMdd to yyyyMM.
  3. Renamed msexports_extract pipeline to msexports_ExecuteETL.
  4. Renamed msexports_transform pipeline to msexports_ETL_ingestion.

📊 Power BI reports

➕ Added:

  1. Cost Management connector report to support the Cost Management connector.

✏️ Changed:

  1. Updated Cost summary and Commitment discounts reports to FOCUS 1.0 preview.
  2. Updated Cost summary and Commitment discounts reports to only use FinOps hubs.
  3. Removed unused custom visualizations.
  4. Organized setup instructions in Cost summary to match other reports.
  5. Updated troubleshooting documentation.

🛠️ Fixed:

  1. Removed sensitivity labels.
  2. Fixed dynamic data source error when the Power BI service refreshes data.
    • Error message: “You can’t schedule refresh for this semantic model because the following data sources currently don’t support refresh…”
  3. Fixed error in ChargeId column when ResourceId is empty.
  4. Removed the ChargeId column due to it bloating the data size.
    • The field is commented out. If interested, you can enable uncomment it in the ftk_NormalizeSchema function. Just be aware that it duplicates a lot of columns to ensure uniqueness which bloats the data size significantly.
  5. Fixed null error when Billing Account ID is empty (#473).
  6. Added missing commitment discount refunds to the actual cost data (#447).

📒 Azure Monitor workbooks

➕ Added:

  • Optimization workbook:
    1. Storage: Identify Idle Backups: Review protected items’ backup activity to spot items not backed up in the last 90 days.
    2. Storage: Review Replication Settings: Evaluate and improve your backup strategy by identifying resources with default geo-redundant storage (GRS) replication.
    3. Networking: Azure Firewall Premium Features: Identify Azure Firewalls with Premium SKU and ensure associated policies leverage premium-only features.
    4. Networking: Firewall Optimization: Streamline Azure Firewall usage by centralizing instances in the hub virtual network or Virtual WAN secure hub.

✏️ Changed:

  • Optimization workbook:
    1. Top 10 services: Improved Monitoring tabs: Enhance your monitoring experience with updated Azure Advisor recommendations for Log Analytics.

🛠️ Fixed:

🖥️ PowerShell

➕ Added:

  1. New-FinOpsCostExport to create and update Cost Management exports.
  2. Start-FinOpsCostExport to run a Cost Management export immediately.
  3. Get-FinOpsCostExport now has a -RunHistory option to include the run history of each export.

✏️ Changed:

  1. Updated the default API version for export commands to 2023-07-01-preview to leverage new datasets and features.
    • Specify 2023-08-01 explicitly for the previous API version.

🛠️ Fixed:

  1. Fixed typo in Deploy-FinOpsHub causing it to fail.

🗑️ Removed:

  1. ConvertTo-FinOpsSchema and Invoke-FinOpsSchemaTransform are no longer being maintained and will be removed in a future update.
    • With native support for FOCUS 1.0 preview in Cost Management, we are deprecating both commands, which only support FOCUS 0.5.
    • If you would like to see the PowerShell commands updated to 1.0 preview, please let us know in discussions or via a GitHub issue.

🌐 Open data

➕ Added:

  1. Resource types to map Azure resource types to friendly display names.
  2. Get-FinOpsResourceType PowerShell command to support resource type to display name mapping.
  3. Sample exports for each of the datasets that can be exported from Cost Management.

📗 FinOps guide

➕ Added:

  1. FinOps Open Cost and Usage Specification (FOCUS) details.

Download v0.2 Full changelog


🛠️ v0.1.1

🖥️ PowerShell

➕ Added:

  1. New PowerShell commands to convert data to FOCUS 0.5:
    1. ConvertTo-FinOpsSchema
    2. Invoke-FinOpsSchemaTransform
  2. New PowerShell commands to get and delete Cost Management exports:
    1. Get-FinOpsCostExport
    2. Remove-FinOpsCostExport

🌐 Open data

➕ Added:

  1. New PowerShell commands to integrate open data to support data cleansing:
    1. Get-FinOpsPricingUnit
    2. Get-FinOpsRegion
    3. Get-FinOpsService

🏦 FinOps hubs

➕ Added:

  1. New PowerShell commands to manage FinOps hubs 0.1:
    1. Get-FinOpsHub
    2. Initialize-FinOpsHubDeployment
    3. Register-FinOpsHubProviders
    4. Remove-FinOpsHub

Download v0.1.1 Full changelog


🚚 v0.1

🖥️ PowerShell

➕ Added:

  1. FinOpsToolkit module released in the PowerShell Gallery.
  2. Get-FinOpsToolkitVersion to get toolkit versions.

🏦 FinOps hubs

➕ Added:

  1. Deploy-FinOpsHub to deploy or update a hub instance.
  2. Get-FinOpsHub to get details about a hub instance.
  3. Support for Microsoft Customer Agreement (MCA) accounts and Cloud Solution Provider (CSP) subscriptions in Power BI reports.

🛠️ Fixed:

  1. Storage redundancy dropdown default not set correctly in the create form.
  2. Tags specified in the create form were causing the deployment to fail (#331).

📊 Power BI reports

➕ Added:

  1. Commitments, Savings, Chargeback, Purchases, and Prices pages in the Commitment discounts report.
  2. Prices page in the Cost summary report.
  3. FOCUS sample report – See your data in the FinOps Open Cost and Usage Specification (FOCUS) schema.
  4. Cost Management template app (EA only) – The original Cost Management template app as a customizable PBIX file.

✏️ Changed:

  1. Expanded the FinOps hubs Cost summary and Commitment discounts Power BI reports to support the Cost Management connector.

📒 Azure Monitor workbooks

➕ Added:

  1. Governance workbook to centralize governance.

✏️ Changed:

  1. Optimization workbook updated to cover more scenarios.

🌐 Open data

➕ Added:

  1. Pricing units to map all pricing units (UnitOfMeasure values) to distinct units with a scaling factor.
  2. Regions to map historical resource location values in Microsoft Cost Management to standard Azure regions.
  3. Services to map all resource types to FOCUS service names and categories.

Download v0.1 Full changelog


🌱 v0.0.1

🏦 FinOps hubs

➕ Added:

  1. FinOps hub template to deploy a storage account and Data Factory instance.
  2. Cost summary report for various out-of-the-box cost breakdowns.
  3. Commitment discounts report for commitment-based discount reports.

🦾 Bicep modules

➕ Added:

  1. Scheduled action modules submitted to the Bicep Registry.

📒 Azure Monitor workbooks

➕ Added:

  1. Cost optimization workbook to centralize cost optimization.

Download v0.0.1 Full changelog


This site uses Just the Docs, a documentation theme for Jekyll.