Power BI reports Accelerate your analytics efforts with simple, targeted reports. Summarize and break costs down, or customize to meet your needs.
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.
If youβre just getting started and have less than $2-5 million to report on, start with the Cost Management connector report that leverages the Microsoft Cost Management connector for Power BI. If you run into performance issues or need to report on more than $5 million, use FinOps hubs with the other available reports and configure incremental refresh. The main difference between the two is that the connector is built into Power BI and requires no external setup, while FinOps hubs requires resources to be deployed to your subscription, which enable additional capabilities. Most organizations can use the connector, depending on the reporting requirements. FinOps hubs is generally for more advanced scenarios. For details, see Help me choose.
As of FinOps toolkit 0.2, all reports have been updated to use the FinOps Open Cost and Usage Specification (FOCUS). To learn more, see About FOCUS.
π 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 FinOps hubs:
- Cost summary β Overview of amortized costs with common breakdowns.
- Commitment discounts β Summarizes existing and potential savings from commitment-based discounts.
- 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.
- Cost Management connector β Summarizes costs, savings, and commitment discounts using the Cost Management connector.
- Cost Management template app (EA only) β The original Cost Management template app as a customizable PBIX file.
βοΈ 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:
- 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.
- Coming soon: For costs under $2-5M/month (~$65M total)2 that need savings plan data, you can use raw exports with Power BI.
- This is in preview and will be included in a future FinOps toolkit release.
- To enable the preview, see the βExports (preview)β feature in Cost Management Labs.
- For costs under $2-5M/month (~$65M total)2 that need savings plan data, you can use FinOps hubs with Power BI.
- Requires incremental refresh to be enabled to load more than $5M over multiple months.
- 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 | Exports1 | FinOps hubs | Microsoft Fabric2 |
---|---|---|---|---|
Cost | $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 month3 | $2M/mo (Pro) $5M/mo (Premium) | $2M/mo (Pro) $5M/mo (Premium) | $2M/mo (Pro) $5M/mo (Premium) | TBD |
Est. max total with incremental refresh4 | $2M (Pro) $5M (Premium) | $2M (Pro) $65M (Premium) | $2M (Pro) $65M (Premium) | TBD |
Does not require a deployment | β | β (storage only) | β (details) | β |
Latest API version5 | β | β | β | β |
Azure Government | β | π | β | β (Hubs) |
Azure China | β | π | β | β (Hubs) |
Enterprise Agreement | β | β | β | β |
Microsoft Customer Agreement | β | β | β | β |
Microsoft Partner Agreement | β | β | β | β |
Microsoft Online Services Agreement | β | β (if requested) | β (if requested) | β |
Billing accounts | β | β | β | β |
Billing profiles | β | β | β | β |
Invoice sections | β | β | β | β |
CSP customers (partner only) | β | β | β | β |
Management groups | β | β | β (if requested) | β |
Subscriptions | β | β | β | β |
Resource groups | β | β | β | β |
Supports savings plans5 | β | β | β | β |
Supports savings plan recommendations | β | β | π (0.4) | π |
Supports multiple scopes | β | β | β | β |
Supports scopes in different tenants | β | β | π (0.3) | π (Hubs) |
Faster data load times | β | π | β | β (Hubs) |
Supports >$65M in cost details | β | β | π (0.4) | β |
Analytical engine | β | β | π (0.4) | β |
Accessible outside of Power BI | β | β | β | β |
Learn more | Learn more | Β | Learn more | Β |
1) Support for raw exports requires a Cost Management preview feature available from Cost Management Labs. The FinOps toolkit does not support raw exports yet but will in a future release.
2) 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.
3) 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.
4) 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.
5) 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.
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.
-
Select the Transform data button (table with a pencil icon) in the toolbar.
-
Select Queries > π οΈ Setup > Instructions > βΆ START HERE and follow the instructions.
To connect to a FinOps hub instance, you will need the
storageUrlForPowerBI
value from the deployment outputs. Make sure you have the Storage Blob Data Reader role on the storage account so you can access the data.To connect to the Cost Management connector, you will need the billing account ID and/or billing profile ID. You can find this in Cost Management configuration settings > Properties.
-
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.
π§° Related tools
- π¦ FinOps hubs β Open, extensible, and scalable cost reporting.
- π Cost optimization workbook β Central hub for cost optimization.
- π Governance workbook β Central hub for governance.
- π Open data β Data available for anyone to access, use, and share without restriction.