Analyze subscription billing data with Power BI reports

Important

Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned

Enabled for Public preview General availability
Users, automatically - May 2025

Business value

The new Power BI app for subscription billing data analysis provides you with comprehensive insights into your business. With detailed reports and KPIs, you can monitor critical metrics like monthly recurring revenue and net monthly recurring profit, helping you make informed decisions.

The app's granular insights into revenue by item, customer, and salesperson optimizes your sales and marketing efforts, while tracking customer and vendor deferrals improves cash flow management. Overall, this app enhances your ability to drive your subscription business forward and improve your bottom line.

Feature details

A new Power BI app has been added to help you analyze your subscription billing data.

Screenshot of the Subscription Billing Overview report

The app contains reports such as:

  • Subscription Overview
  • Revenue Year-Over-Year
  • Revenue Analysis
  • Revenue Development
  • Revenue by Item
  • Revenue by Customer
  • Revenue by Salesperson
  • Total Contract Value
  • Year-Over-Year Total
  • Contract Value Analysis
  • Customer Deferrals Vendor

To help you track important metrics for your subscription business, the semantic model for the report includes KPIs such as:

  • Monthly Recurring Revenue
  • Monthly Recurring Cost
  • Net Monthly Recurring Profit
  • MRR Churn
  • MRR Downgrade
  • MRR New
  • MRR Upgrade
  • MRR Change Usage Based Billing
  • MRR Overall Change
  • Active Customers
  • Total Contract Value
  • Revenue Forecast
  • Customer Deferrals
  • Vendor Deferrals

Tell us what you think

Help us improve Dynamics 365 Business Central by discussing ideas, providing suggestions, and giving feedback. Use the forum at https://aka.ms/bcideas.