Skip to content

[Bug/Feature Request] FinOps Hub v13 – Need aggregation by Cost Center instead of Subscription + missing Cost Center sync #2059

@BoubakriMohamed404

Description

@BoubakriMohamed404

Context / Business Need:

We need to customize the Azure FinOps Hub v13 default Power BI report (Storage Account export) so that costs are grouped by Cost Center (project/budget) instead of being grouped by Subscription.
Multiple subscriptions belong to the same project (same budget), so the expected report behavior is:
➡️ One consolidated cost line per Cost Center
➡️ With the ability to drill down into subscriptions and resources

Problem Description

Attempt 1 — Using the custom Azure tag cost_center (tag in subscription +RG +resources)

When we use the tag to group resources in Power BI, there is always a gap between:

The sum of the subscriptions belonging to the project
The sum of the resources filtered by cost_center:project01, for example

Reason:
➡️ Many Azure resources do not support tags by default , so the tag-based filtering never fully matches the subscription totals.

Attempt 2 — Editing the Cost Center directly in Azure (Cost Management + Billing)

Image

We tried updating the Cost Center field in cost and billing directly.
After refreshing FinOps Hub and power bi:

Image

The updated Cost Center value does NOT appear in the tables consumed by the Power BI report
FinOps Hub v13 seems not to ingest or expose this billing Cost Center field
We could not find a way to group by subscription Cost Center, because tags exist only at resource level, not at subscription level in the power bi report default schema (no subscription tags ligne )

Image

This makes it impossible to build a reliable “per Cost Center” view.

Observed Behavior

  • Inconsistent results between subscription totals and cost-center-tag-based totals
  • Cost Center changes from Azure Cost Management + Billing never show up in the FinOps Hub dataset
  • No built‑in way to group costs by subscription → cost center

Steps to Reproduce

Deploy FinOps Hub v13 with Storage Account +power bi report
Tag some resources with centre_de_cout
Compare:

Sum of subscriptions for a project X
Sum of resources using the cost center tag

Edit Cost Center in Azure Cost Management + Billing
Refresh FinOps Hub + Power BI
Observe that:

Cost Center billing fields are not included
Tag-only aggregation creates mismatches

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions