Centrailsed cost management reporting

Centralized cost management reporting for multiple, separate Azure tenants (for a non-partner) is best approached by combining tenant-level tagging and cost exports with a common reporting layer such as Power BI.

1. Define what must be measured per tenant
   • Decide whether costs must be:
     • Approximate (for internal showback/chargeback or rough cost of goods sold), or
     • Precise (for per-tenant billing or strict profitability analysis).
   • This decision drives how much engineering is invested in tagging, metering, and data pipelines.
2. Standardize a tagging strategy across all tenants
   • Apply a consistent set of tags to resources in every tenant so they can be grouped and allocated in a uniform way.
   • For multitenant or shared components, use tags such as:
     • stamp-id for deployment stamp or environment segment.
     • shard-id for shared databases or other sharded resources.
     • tenant-id only on resources dedicated to a single tenant.
   • Avoid tagging every shared resource with every tenant ID; instead, tag with shard or stamp identifiers and allocate shared costs proportionally outside Azure.
   • After tags are applied, use Azure Cost Management’s ability to determine costs associated with each tag per tenant.
3. Use Cost Management exports or APIs per tenant
   • In each tenant, configure Cost and Usage Exports to a storage account to get raw cost data (daily or monthly). Scheduled exports are the most scalable option for integrating cost data into a central system.
   • Alternatively, use the Cost Details API per tenant when finer control over queries is required.
   • Ensure exports include tags so that downstream processing can allocate costs by tenant, shard, or stamp.
4. Build a centralized reporting data store
   • Land all tenant exports into a central data sink (for example, a data lake or database) that is outside the individual tenants’ subscriptions.
   • Normalize schemas and enrich with internal metadata (for example, mapping stamp-id/shard-id to business tenants, departments, or SKUs).
   • Implement allocation logic for shared components (for example, evenly split by tenant count on a shard, or weighted by usage metrics if available).
5. Use Power BI for consolidated dashboards
   • Use the Cost Management template app or the Cost Management connector for Power BI to connect to cost data.
   • Either:
     • Connect Power BI directly to each tenant’s Cost Management data and model them together, or
     • Preferably, connect Power BI to the centralized data store that already aggregates and allocates costs from all tenants.
   • Build reports that show:
     • Costs per tenant, per tag, per subscription, and per shared stamp/shard.
     • Trends, forecasts, and cost variance for showback/chargeback.
6. Implement showback/chargeback processes
   • Use the centralized dataset to generate cost reports that include:
     • Incurred costs (actual metered usage per tenant or per internal business unit).
     • Prepaid costs (for example, reservations or savings plans) amortized and allocated across tenants.
     • Trends, forecasts, credits, and cost variance.
   • Integrate these reports into internal financial processes for showback or chargeback.
7. Optimize costs across tenants
   • Once centralized visibility is in place, use Azure reservations and Azure savings plans for compute at the portfolio level, not per tenant, then allocate the benefit back to tenants via the central model.
   • Use the shared tagging model to identify expensive stamps/shards and rebalance tenants or adjust capacity.
8. Avoid common antipatterns
   • Do not ignore cost tracking or rely on guesses; base allocations on actual exported data.
   • Do not overengineer for real-time precision unless strictly required; daily exports and batch processing are usually sufficient.
   • Do not use monitoring tools like Application Insights as the primary billing source; use Cost Management data and, if needed, a custom metering pipeline for precise per-tenant usage.

This combination—standardized tags in each tenant, scheduled Cost Management exports or APIs, a central cost data sink, and Power BI-based reporting—provides a scalable, centralized cost management solution for multiple separate tenants without requiring partner capabilities.

References:

• Get started with Cost Management reporting
• Architectural approaches for cost management and allocation in a multitenant solution
• Architecture strategies for collecting and reviewing cost data