ConvertTo-FinOpsSchema Converts Cost Management cost data to the FinOps Open Cost and Usage Specification (FOCUS) schema.
On this page
The ConvertTo-FinOpsSchema command was implemented before Microsoft Cost Management supported a native FOCUS export. Going forward, we recommend using the native export. The ConvertTo-FinOpsSchema command will remain available but will not be updated to support FOCUS 1.0-preview. If you have a scenario where you need a PowerShell converter, please leave feedback at aka.ms/ftk.
The ConvertTo-FinOpsSchema command returns an object that adheres to the FinOps Open Cost and Usage Specification (FOCUS) schema.
ConvertTo-FinOpsSchema currently understands how to convert Cost Management cost data using the latest schemas as of September 2023. Older schemas may not be fully supported. Please review output and report any issues to aka.ms/ftk.
You can pipe objects to ConvertTo-FinOpsSchema from an exported or downloaded CSV file using Import-Csv or ConvertFrom-Csv and pipe to Export-Csv to save as a CSV file. Or use the Invoke-FinOpsSchemaTransform command to simplify the process.
🧮 Syntax
ConvertTo-FinOpsSchema `
[-ActualCost <object>] `
[-AmortizedCost <object>]
📥 Parameters
| Name | Description |
|---|---|
| ActualCost | Required. Specifies the actual cost data to be converted. Object must be a supported Microsoft Cost Management schema. |
| AmortizedCost | Required. Specifies the amortized cost data to be converted. Object must be a supported Microsoft Cost Management schema. |
🌟 Examples
Get all hubs
ConvertTo-FinOpsSchema `
-ActualCost (Import-Csv my-actual-cost-details.csv) `
-AmortizedCost (Import-Csv my-amortized-cost-details.csv) `
| Export-Csv my-cost-details-in-focus.csv
Converts previously downloaded actual and amortized cost details to FOCUS 0.5 and saves it as a CSV file.
🧰 Related tools
- 🏦 FinOps hubs – Open, extensible, and scalable cost reporting.
- 📊 Power BI reports – Accelerate your reporting with Power BI starter kits.
- 🌐 Open data – Data available for anyone to access, use, and share without restriction.