Power BI reports Accelerate your analytics efforts with simple, targeted reports. Summarize and break costs down, or customize to meet your needs.

Download Connect your data

On this page

The FinOps toolkit Power BI reports provide a great starting point for your FinOps reporting. We recommend customizing them to keep what works, edit and augment reports with your own data, and remove anything that isn’t needed. You can also copy and paste visuals between reports to create your own custom reports.

FinOps toolkit reports support several ways to connect to your cost data. We generally recommend starting with Cost Management exports, which supports up to $2-5 million in monthly spend. If you experience data refresh timeouts or need to report on data across multiple directories or tenants, please use FinOps hubs, a data pipeline solution that optimizes data and offers additional functionality. For additional details and help choosing the right backend, see Help me choose.

Please note support for the Cost Management connector for Power BI is available for backwards compatibility, but is not recommended. The Microsoft Cost Management team is no longer updating the Cost Management connector and instead recommends exporting data.


📈 Available reports

The FinOps toolkit includes two sets of reports that connect to different data sources. We recommend using the following reports which connect to Cost Management exports or FinOps hubs:

  • Cost summary – Overview of amortized costs with common breakdowns.
  • Rate optimization – Summarizes existing and potential savings from commitment discounts.
  • Workload optimization – Summarizes opportunities to achieve resource cost and usage efficiencies.
  • Cloud policy and governance – Summarize cloud governance posture including areas like compliance, security, operations, and resource management.
  • Data ingestion – Provides insights into your data ingestion layer.

The following reports use the Cost Management connector for Power BI to connect to your data. While the connector is not recommended due to the reasons below, these reports will be available as long as the connector is supported by the Cost Management team.

Download How to setup


⚖️ Help me choose

Microsoft offers several ways to analyze and report on your cloud costs. For quick exploration of subscriptions and billing accounts, we recommend starting with smart views in Cost analysis in the Azure portal or Microsoft 365 admin center. When you need more control or to save and share charts, switch to customizable views.

When you need more advanced reporting or to merge with your own data, we recommend using Microsoft Fabric, Power BI, or a custom or third-party solution. Use the following to determine the best approach for you:

  1. For costs under $2-5M in total1 that don’t need savings plan data, you can use the Cost Management connector for Power BI.
    • The connector uses existing raw cost data APIs and cannot scale to data sizes beyond $5M1.
    • Due to the size constraints, the connector will be phased out by the Cost Management team starting in 2024.
    • The APIs do not include some key columns for savings plans, like the BenefitId/Name columns. All costs are covered but not always easily identifiable.
  2. For costs under $2-5M/month (~$65M total)2 that need savings plan data, you can use raw exports with Power BI.
  3. For costs under $2-5M/month (~$65M total)2 that need savings plan data, you can use FinOps hubs with Power BI.
  4. Coming soon: For costs over $5M/month or for additional capabilities, you can connect Fabric to either FinOps hubs or raw exports.
    • This is possible today, but is not supported in FinOps toolkit reports yet. Support will be added in a future release.

1) Power BI Pro can handle ~$2M of raw cost data. Power BI Premium can handle ~$5M.

2) The $2-5M limits are for Power BI data refreshes and apply on a monthly basis for hubs and raw exports. They can load up to $65M with incremental refresh enabled.

In general, we recommend starting with the Cost Management connector when getting started with Power BI reports. The most common reasons to switch to FinOps hubs are for additional account types and scopes or to enable more advanced capabilities. Use the following comparison to help you make the decision:

Capabilities Connector Exports FinOps hubs Microsoft Fabric1
Cost (based on list prices) $0 ~$10 per $1M ~$25 per $1M TBD
Data storage Power BI Data Lake Storage Data Lake Storage Data Lake Storage
Est. max raw cost details per month2 $2M/mo (Pro)
$5M/mo (Premium)		 $2M/mo (Pro)
$5M/mo (Premium)		 $2M/mo (Pro)
$5M/mo (Premium)		 TBD
Est. max total with incremental refresh3 $2M (Pro)
$5M (Premium)		 $2M (Pro)
$65M (Premium)		 $2M (Pro)
$65M (Premium)		 TBD
Does not require a deployment ✅ ❌ (storage only) ❌ (details) ❌
Latest API version4 ❌ ✅ ✅ ✅
Azure Government ❌ 🔜 ✅ (0.1.1) ✅ (via Hubs)
Azure China ❌ 🔜 ✅ (0.1.1) ✅ (via Hubs)
Enterprise Agreement ✅ ✅ ✅ ✅
Microsoft Customer Agreement ✅ ✅ ✅ ✅
Microsoft Partner Agreement ✅ ✅ ✅ ✅
Microsoft Online Services Agreement ❌ ❌ ❌ ❌
Billing accounts ✅ ✅ ✅ ✅
Billing profiles ✅ ✅ ✅ ✅
Invoice sections ❌ ✅ ✅ ✅
CSP customers (partner only) ❌ ✅ ✅ ✅
Management groups ❌ ❌ ❌ ❌
Subscriptions ❌ ✅ ✅ ✅
Resource groups ❌ ✅ ✅ ✅
Supports savings plans4 ❌ ✅ ✅ ✅
Supports savings plan recommendations ❌ ❌ 🔜 🔜
Supports multiple scopes ❌ ✅ ✅ ✅
Supports scopes in different tenants5 ❌ ❌5 ✅ ✅ (via Hubs)
Faster data load times ❌ 🔜 ✅ ✅ (via Hubs)
Supports >$65M in cost details ❌ ❌ 🔜 (0.7) ✅
Analytical engine ❌ ❌ 🔜 (0.7) ✅
Accessible outside of Power BI ❌ ✅ ✅ ✅
Learn more Learn more   Learn more  

1) Microsoft Fabric can connect to either raw exports or FinOps hubs. FinOps toolkit reports do not support Microsoft Fabric yet but will in a future release.

2) Power BI constraints are based on data size and processing time. Monitored spend estimations are for reference only. You may see different limits based on services you use and other datasets you ingest.

3) The Cost Management connector for Power BI does not support incremental refresh, so the limits are the same as the per-month estimation. The FinOps hub estimate is based on incremental refresh being enabled, which requires additional configuration after your report is published.

4) The Cost Management connector uses an old API version and does not include details for some features, like savings plans. Please use FinOps hubs for the latest version with all details.

5) EA billing scopes can be exported to any tenant today. Simply sign in to that tenant with an account that has access to the billing scope and target storage account to configure exports. Non-billing scopes (subscriptions, management groups, and resource groups) and all MCA scopes are only supported in the tenant they exist in today but will be supported via a “remote hubs” feature in a future FinOps hubs release.

If you’re not sure, start with the Cost Management connector. You will usually be able to tell if that works for you within the first 5-10 minutes. If you experience delays in pulling your data, try requesting fewer months. If you still experience issues, it’s time to consider switching to FinOps hubs.


✨ Connect to your data

All FinOps toolkit reports, come with sample data to explore without connecting to your account. Reports have a built-in tutorial to help you connect to your data.

  1. Configure Cost Management exports for any data you would like to include in reports, including:

    • Cost and usage (FOCUS) – Required for all reports.
    • Price sheet
    • Reservation details
    • Reservation recommendations – Required to see reservation recommendations in the Rate optimization report.
    • Reservation transactions

  2. Select the Transform data button (table with a pencil icon) in the toolbar.

    Screenshot of the Transform data button in the Power BI Desktop toolbar.

  3. Select Queries > 🛠️ Setup > ▶ START HERE and follow the instructions.

    Make sure you have the Storage Blob Data Reader role on the storage account so you can access the data.

    Screenshot of instructions to connect to a storage account

  4. Select Close & Apply in the toolbar and allow Power BI to refresh to see your data.

For more details, see How to setup Power BI.


🙋‍♀️ Looking for more?

We’d love to hear about any reports, charts, or general reporting questions you’re looking to answer. Create a new issue with the details that you’d like to see either included in existing or new reports.

Share feedback


🧰 Related tools

  • 🏦 FinOps hubs – Open, extensible, and scalable cost reporting.
  • 📒 FinOps workbooks – Customizable home for engineers to maximize cloud ROI through FinOps.
  • 🌐 Open data – Data available for anyone to access, use, and share without restriction.


Table of contents

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