Tools for AVD Chargeback and Showback
    • Dark
      Light
    • Download PDF

    Tools for AVD Chargeback and Showback

    • Dark
      Light
    • Download PDF

    Article summary

    Quick Answer:  The best tools for AVD chargeback and showback are: Azure Cost Management + Billing (free, native — best for showback via tag-based cost views and scheduled exports), Power BI with the Cost Management connector (free — best for custom chargeback dashboards shared with department heads), Nerdio Manager (paid — best for organizations wanting AVD-specific cost reporting built-in), and Microsoft Fabric / Excel exports for teams that need chargeback data integrated into existing finance workflows. Showback requires only tagging + Cost Management. True chargeback — where departments are invoiced — additionally requires a cost allocation formula and a finance integration layer.

    Chargeback vs. Showback: What's the Difference?

    Before choosing tools, it's critical to understand what you're building — because showback and chargeback are fundamentally different in scope and organizational impact.

    Showback

    • Departmentsseetheir AVD costs but are not invoiced

    • Creates awareness and accountability without budget transfer

    • Easier to implement — requires only tagging + reporting

    • Good starting point for organizations new to FinOps

    • Finance approval process not required

    • Suitable for centralized IT funding models

    Chargeback

    • Departments areinvoicedfor their actual AVD consumption

    • Requires finance system integration for billing

    • Creates real financial accountability and behavior change

    • Requires agreed cost allocation formula

    • Needs finance and legal sign-off in many organizations

    • Suitable for decentralized budget models

    Recommendation:  Start with showback for 1–2 quarters to establish baseline costs and build stakeholder trust. Then transition to chargeback once departments understand their cost drivers and have had the opportunity to optimize their usage. Jumping to chargeback without a showback period typically generates organizational friction and disputes over cost attribution methodology.

    The Foundation: Tagging for Cost Attribution

    No chargeback or showback tool works without clean, consistent tagging. Every AVD resource — host pools, session host VMs, storage accounts, key vaults — must carry a Department tag (or equivalent) before any tool can split costs by business unit.

    At minimum, apply these tags to all AVD resources before implementing any chargeback tooling:

    • Department— the business unit that consumes this host pool (Finance, HR, Engineering)

    • HostPool— the name of the AVD host pool (enables per-pool cost splits)

    • CostCenter— the finance cost center code for direct ERP integration

    • Environment— Production, Dev, UAT (prevents dev costs from appearing in department chargebacks)

    Tool 1 — Azure Cost Management + Billing (Native, Free)

    Native  Free

    Azure Cost Management + Billing

    Best for:  Showback. Generating tag-based cost views by department and scheduling automated exports for finance stakeholders.

    Azure Cost Management is the native starting point for all AVD cost attribution. With proper tagging in place, you can create saved cost analysis views filtered by the Department tag, and use the Scheduled Exports feature to send a monthly CSV of AVD costs by department directly to a storage account — from which finance teams or Power BI can consume the data.

    Configuring a Showback View by Department

    • In Cost Management → Cost Analysis, set scope to the AVD subscription or resource group

    • Set Group by: Tag → Department

    • Set date range to the current billing period

    • Click Save as to create a named view: "AVD Cost by Department"

    • Share the view URL with stakeholders — read-only portal access is sufficient for showback

    Setting Up Monthly Scheduled Exports

    # Azure CLI — Create monthly AVD cost export

    az costmanagement export create \

    --name "avd-monthly-dept-export" \

    --scope "/subscriptions/{sub-id}/resourceGroups/rg-avd-prod" \

    --type ActualCost \

    --dataset-granularity Monthly \

    --schedule-recurrence Monthly \

    --schedule-start-date "2025-06-01T00:00:00Z" \

    --storage-account-id "/subscriptions/{sub-id}/resourceGroups/rg-exports/providers/Microsoft.Storage/storageAccounts/saavdexports" \

    --storage-container "avd-cost-exports" \

    --storage-directory "monthly"

    Limitation:  Azure Cost Management cannot generate per-user cost attribution natively — it attributes costs at the resource level. For per-user chargeback, you need to combine this data with AVD Insights session-hour data to calculate a cost-per-user allocation.

    Tool 2 — Power BI + Cost Management Connector

    Native Requires Power BI Pro ($10/user/mo)

    Power BI with Azure Cost Management Connector

    Best for: Custom chargeback dashboards shared monthly with department heads and finance teams, with drill-down capability by host pool, VM, and time period.

    Power BI's built-in Azure Cost Management connector pulls billing data directly from your enrollment or subscription and refreshes automatically. Combined with AVD Insights data exported to Log Analytics, you can build a single dashboard that shows cost-per-user by department — the gold standard for AVD chargeback reporting.

    Building an AVD Chargeback Report in Power BI

    • In Power BI Desktop: Get Data → Azure → Azure Cost Management

    • Connect to your billing scope (subscription or billing account)

    • Import the UsageDetails table — this contains resource-level costs with tags

    • Add a second data source: the Log Analytics workspace containing AVD Insights session data (WVDConnectionstable)

    • Join the two datasets on the date dimension to calculate cost-per-user-hour by department

    • Build visuals: monthly cost by department bar chart, cost per user trend line, host pool cost breakdown table

    • Publish to Power BI Service and share with department heads via a Power BI App

    Per-User Cost Calculation in Power BI (DAX)

    // DAX measure: Cost Per AVD User (monthly)

    CostPerUser =

    DIVIDE(

    SUMX(FILTER(UsageDetails, UsageDetails[Tags.Department] = SELECTEDVALUE(DeptTable[Department])),

    UsageDetails[PreTaxCost]),

    COUNTX(FILTER(AVDSessions, AVDSessions[Department] = SELECTEDVALUE(DeptTable[Department])),

    DISTINCT(AVDSessions[UserName]))

    )

    Tool 3 — Nerdio Manager for Enterprise

    Third-Party  Paid

    Nerdio Manager for Enterprise

    Best for: Organizations that want AVD-specific cost management, chargeback, and auto-scaling in a single platform without building custom Power BI reports.

    Nerdio Manager is the leading third-party AVD management platform, and it includes built-in cost estimation, per-host-pool cost tracking, and a chargeback module that can generate department cost reports without requiring any custom development. Its Cost Estimator tool models the cost impact of configuration changes before they are applied — a capability not available in native Azure tooling.

    Nerdio Chargeback Capabilities

    • Per-host-pool cost tracking with automatic mapping to departments

    • Built-in chargeback report export (CSV/PDF) by billing period

    • Cost forecasting based on historical session usage patterns

    • Session host cost-per-user calculation built into the dashboard

    • Integration with Azure Cost Management for unified cost visibility

    Tool 4 — Microsoft Fabric (Cost Analytics at Scale)

    Microsoft Requires Fabric Capacity

    Microsoft Fabric — Cost Analytics Pipeline

    Best for: Large enterprises (1,000+ AVD users) that need automated chargeback data integrated into their ERP or finance system (SAP, Dynamics 365) on a monthly billing cycle.

    Microsoft Fabric enables you to build a fully automated cost analytics pipeline: ingest Azure Cost Management exports from Blob Storage into a Fabric Lakehouse, transform and enrich the data with AVD session data from Log Analytics, calculate per-department and per-user costs, and write the output directly to Dynamics 365 Finance or SAP as chargeback entries — eliminating manual finance team intervention.

    Tool Comparison Matrix

    Tool

    Showback

    Chargeback

    Per-User Cost

    Cost

    Best For

    Azure Cost Management

    ✅ Native

    ⚠ Manual export

    Free

    Starting point, small teams

    Power BI + CM Connector

    ✅ Excellent

    ✅ Custom reports

    ✅ Via DAX

    ~$10/user Power BI Pro

    Custom dashboards, finance teams

    Nerdio Manager

    ✅ Built-in

    ✅ Built-in

    ✅ Built-in

    Vendor pricing

    AVD-first orgs wanting turnkey solution

    Microsoft Fabric

    ✅ Advanced

    ✅ ERP-integrated

    ✅ Automated

    Fabric F SKU

    Enterprise with ERP integration needs

    CloudHealth / Apptio

    ⚠ Limited AVD context

    Enterprise pricing

    Multi-cloud FinOps at scale


    Was this article helpful?

    ESC

    Eddy AI, facilitating knowledge discovery through conversational intelligence