Power BI apps/reports for functional areas

Power BI apps are available for the following functional areas in Business Central:

  • Finance
  • Inventory
  • Inventory Valuation
  • Manufacturing
  • Projects
  • Purchasing
  • Sales
  • Subscription Billing
  • Sustainability

To explore each app, use the links in the following table, or read more about reports in the sections that follow.

Replace legacy Power BI apps and insights

The legacy Dynamics 365 Business Central - CRM, Dynamics 365 Business Central - Finance, and Dynamics 365 Business Central - Sales apps on Microsoft Marketplace are obsolete. Use the current apps to analyze your financial and sales data.

Legacy appCurrent reporting features
Dynamics 365 Business Central - CRMUse the Power BI Sales app, including Opportunity Overview, to analyze sales opportunities and sales cycles.
Dynamics 365 Business Central - FinanceUse the Power BI Finance app to analyze financial performance.
Dynamics 365 Business Central - SalesUse the Power BI Sales app to analyze sales performance, customers, and items.

The Intelligent Cloud Insights feature is also obsolete. For insights into cash availability, net income, sales profitability, and inventory value, explore the Power BI Finance app, Power BI Sales app, and Power BI Inventory Valuation app.

Learn more about supported versions and connecting the current apps to your data in Install Power BI apps for Business Central.

Data models and KPIs

Each of the Power BI apps for Business Central includes a semantic model with star schemas that support the reports, as well as KPIs implemented as measures. In the following sections, you can find documentation for these models and KPIs. This documentation helps you understand how numbers are calculated and guides you if you want to implement your own star schemas and KPIs. For the latter case, the documentation might serve as a reference architecture on how data in the Business Central tables relates to common analytics scenarios.

Reports in the Power BI Finance app

The following table describes the reports in the Power BI Finance app, and how you can use them.

To...Open in Business Central (CTRL+select)Learn more
Explore a snapshot of the organization's financial health and performance. This page displays key performance indicators that give stakeholders a clear view of revenue, profitability, and financial stability.Financial OverviewAbout Financial Overview
Analyze and compare income statement accounts on a monthly basis. Use the Income Statement by Month report to gain a comparative view of net changes over time.Income StatementAbout Income Statement
Analyze and compare balance sheet accounts on a monthly basis with the Balance Sheet by Month report. Get a comparative view of balance at date over time.Balance SheetAbout Balance Sheet
Compare G/L budgets to actuals on a month-to-month basis and quickly identify variances.Budget ComparisonAbout Budget Comparison
Analyze your company's liquidity position and track current ratio, quick ratio, and cash ratio over time.Liquidity KPIsAbout Liquidity KPIs
Analyze your company's gross and net profits over time. Get detailed insights into net margins, gross profit margins, and the underlying revenue with the cost and expense figures that drive them.ProfitabilityAbout Profitability
Analyze liability account balances as of a specific date. The report also shows key performance metrics influenced by liabilities, such as the debt ratio and debt-to-equity ratio.LiabilitiesAbout Liabilities
Analyze the EBITDA and EBIT profitability metrics. These figures reveal trends, while also showing operating revenue and operating expenses to provide context for both measures.EBITDAAbout EBITDA
Analyze how many days it takes to collect accounts receivable. Find trends in the average collection period over time. Details such as the number of days, accounts receivable, and accounts receivable (average) provide context and enhance the analysis.Average Collection PeriodAbout Average Collection Period
Categorize customer balances into aging buckets and see a breakdown by payment terms. Age by document date, due date, or posting date, and customize the aging bucket size by specifying the number of days.Aged Receivables (Back Dating)About Aged Receivables (Back Dating)
Categorize vendor balances into aging buckets and review a breakdown by payment terms. Age by document date, due date, or posting date, and customize the aging bucket size by specifying the number of days.Aged Payables (Back Dating)About Aged Payables (Back Dating)
Analyze general ledger entries in detail, and slice G/L entries by all eight shortcut dimensions.General Ledger EntriesAbout General Ledger Entries
Analyze entries posted to the Vendor Ledger and Detailed Vendor Sub Ledger.Detailed Vendor Ledger EntriesAbout Detailed Vendor Ledger Entries
Analyze entries posted to the Customer Ledger and Detailed Customer Sub Ledger.Detailed Customer Ledger EntriesAbout Detailed Customer Ledger Entries
Analyze the behaviors of late paying customers and their financial impact.Late Payments ReceivablesAbout Late Payments (Receivables)

Tip

You can easily track the KPIs that the Power BI reports display against your business objectives. To learn more, go to Track your business KPIs with Power BI metrics.

Learn more in Power BI finance app.

Reports in the Power BI Sales app

The following table describes the reports in the Power BI Sales app and how you can use them.

To...Open in Business Central (CTRL+select)Learn more
Analyze high level information on sales activities. Identify sales figures for quantity or amounts from both posted and unposted documents.Sales OverviewAbout Sales Overview
Analyze sales by weekday over different periods. The heat maps highlight the days on which you sell the most, which helps you identify patterns in your sales.Daily SalesAbout Daily Sales
Analyze sales trends by smoothing out spikes and drops using the 30 Day Moving Averages report.Moving AverageAbout Moving Average
Analyze the aggregated sales over a rolling 12-month period. Use this analysis as an alternative to a Year-to-Date report.Moving Annual TotalAbout Moving Annual Total
Compare sales in one period with the same period in a prior year, quarter, or month.Period-Over-Period GrowthAbout Period-Over-Period Growth
Analyze accumulating sales for a desired period.Month-To-DateAbout Month-To-Date
Analyze sales by item and view key sales metrics as a percentage of total sales.Sales by ItemAbout Sales by Item
Analyze sales by customer and view key metrics. Metrics include sales amount, sales quantity, cost amount, gross profit, gross profit margin, and the sales amount as a percent of total sales.Sales by CustomerAbout Sales by Customer
Analyze sales by salesperson and view key metrics. Metrics include sales amount, sales quantity, cost amount, gross profit, gross profit margin, and the sales amount as a percent of total sales.Sales by SalespersonAbout Sales by Salesperson
Analyze sales by location and view key metrics. Metrics include sales amount, sales quantity, cost amount, gross profit, gross profit margin, and the sales amount as a percent of total sales.Sales by LocationAbout Sales by Location
Analyze item sales budgets against actual sales. View target variances for both sales amounts and sales quantity.Actual vs. BudgetAbout Actual vs. Budget
Analyze sales opportunities and review key metrics. Metrics include estimated values, sales cycles and closed opportunity performance.Opportunity OverviewAbout Opportunity Overview
Analyze high level information on sales quote activities. Identify sales figures related to sales amounts or quantity for prospective customers.Sales Quote OverviewAbout Sales Quote Overview
Analyze high level information on return orders and view key metrics such as the sales amount, sales quantity, and return rate.Return Order OverviewAbout Return Order Overview
Analyze sales performance across demographic segments, and get insights into customer behavior and preferences.Sales DemographicsAbout Sales Demographics
Analyze sales figures to understand contributing factors, such as location names, item categories, and countries and regions.Sales DecompositionAbout Sales Decomposition
Analyze the key factors that drive sales performance. Find the most impactful variables and trends.Key Sales InfluencersAbout Key Sales Influencers
Analyze sales by projects and view key metrics, including sales amount and sales quantity.Sales by ProjectsAbout Sales by Projects
Analyze the forecasted sales amount to gain projected sales insights across customer, salesperson and item.Sales ForecastingAbout Sales Forecasting
Analyze customer retention to gain insights into repeat purchase behavior, customer loyalty, and trends in customer churn over time.Customer Retention OverviewAbout Customer Retention Overview
Analyze historical insights into customer retention metrics, allowing analysis of retention trends over time.Customer Retention HistoryAbout Customer Retention History

Tip

You can easily track the KPIs that the Power BI reports display against your business objectives. To learn more, go to Track your business KPIs with Power BI metrics.

Learn more in Power BI sales app.

Reports in the Power BI Purchasing app

The following table describes how you can use the reports in the Power BI Purchasing app.

To...Open in Business Central (CTRL+select)Learn more
Get a high-level summary of all purchasing activities. View purchase statistics such as summaries of amounts, outstanding amounts, amounts received but not invoiced, and invoiced amounts.Purchases OverviewAbout Purchases Overview
Explore the costs of various components on purchases with a detailed breakdown of your purchasing data by categories, vendors, fiscal month, year, and document types.Purchase DecompositionAbout Purchases Decomposition
Analyze daily purchasing activities and highlight trends and exceptions in daily spend. Monitor day-to-day purchase fluctuations and identify unusual spending patterns.Daily PurchasesAbout Daily Purchases
Analyze the 30-day moving average of your purchases, compare it to the total purchase amount, and identify purchasing trends and patterns.Moving AveragesAbout Moving Averages
Get an overview of the total of all purchases over a rolling 12-month period for long-term trend analysis and forecasting.Moving Annual TotalAbout Moving Annual Total
Compare your purchasing data across different time periods. You can compare at the year, quarter, or month levels, and identify how purchases track across these periods.Period-Over-PeriodAbout Period-Over-Period
Gain insights into your purchasing performance over time. Identify trends or patterns that emerge over time.Year-Over-YearAbout Year-Over-Year
Analyze purchasing activities by vendor by item to gain a better understanding of the items that consume a significant portion of your purchasing budget.Purchases by ItemAbout Purchases by Item
Analyze purchasing activities by vendor to identify which vendors are responsible for most of your purchasing activity.Purchases by VendorAbout Purchases by Vendor
Analyze purchasing activities by purchaser to manage your purchasing teams and individual performance.Purchases by PurchaserAbout Purchases by Purchaser
Gain a comprehensive view of your purchase data across different warehouse locations, and identify trends and patterns in their purchasing activities.Purchases by LocationAbout Purchases by Location
Compare actual spending to allocated budget to ensure that spending aligns with financial plans.Actual vs BudgetAbout Actual vs. Budget
Analyze high level information on return orders and view key metrics such as the purchase amount, purchase quantity, and return rate.Purchase Return OverviewAbout Purchase Return Overview
Analyze high level information on purchase quote activities. Identify purchase figures related to purchase amounts or quantity for prospective vendors.Purchase Quote OverviewAbout Purchase Quote Overview
Analyze the key factors that drive purchasing activities. Find the most impactful variables and trends.Key Purchase InfluencersAbout Key Purchase Influencers
Analyze the forecasted purchase amount to gain projected purchasing insights across vendor, purchaser and item.Purchase ForecastingAbout Purchase Forecasting
Analyze vendor performance across key purchase metrics. Insights include return rate, discount amount, item and spend reliance.Vendor Quality AnalysisVendor Quality Analysis

Tip

You can easily track the KPIs that the Power BI reports display against your business objectives. To learn more, go to Track your business KPIs with Power BI metrics.

Learn more in Power BI Purchasing app.

Reports in the Power BI Inventory app

The following table describes how you can use each report in the Power BI Inventory app.

To...Open in Business Central (CTRL+select)Learn more
Get a high-level view of your organizations inventory and view statistics on scheduled receipt, gross requirements, and inventory across locations.Inventory OverviewAbout Inventory Overview
Review inventory levels for items and gauge how many of an item are on different document types.Inventory by ItemAbout Inventory by Item
Review inventory levels at a location to identify where you keep stock.Inventory by LocationAbout Inventory by Location
Analyze sales and purchase quantities to meet supply and demand.Purchase and Sales QuantityAbout Purchase and Sales Quantity
Get a high-level view of inventory along with the gross requirements, scheduled receipts, and planned production volume.Item AvailabilityAbout Item Availability
Analyze the volume of stock required to meet demand broken down by document type.Gross RequirementAbout Gross Requirement
Analyze the volume of stock you received broken down by document type.Scheduled ReceiptAbout Scheduled Receipt
View inventory quantities based on lot numbers.Inventory by LotAbout Inventory by Lot
View inventory quantities based on serial numbers.Inventory by Serial No.About Inventory by Serial No.
Analyze inventory levels across different bins and identify bins that have active picks.Bin ContentsAbout Bin Contents
Analyze inventory levels across bins and tracking information for the items.Bin Contents by Item TrackingAbout Bin Contents by Item Tracking

Tip

You can easily track the KPIs that the Power BI reports display against your business objectives. To learn more, go to Track your business KPIs with Power BI metrics.

Learn more in Power BI Inventory app.

Reports in the Power BI Inventory Valuation app

The following table describes on how you can use each report in the inventory valuation app.

To...Open in Business Central (CTRL+select)Learn more
Get a high-level view of your inventory value and identify key balances.[Inventory Valuation Overviewhttps://businesscentral.dynamics.com?page=37056)About Inventory Valuation Overview
Review inventory valuation at an item level and see key value figures, including increases and decreases.[Inventory Valuation by Itemhttps://businesscentral.dynamics.com?page=37057)About Inventory Valuation by Item
Review inventory valuation at a location level and see key value figures, including increases and decreases.[Inventory Valuation by Locationhttps://businesscentral.dynamics.com?page=37058)About Inventory Valuation by Location

Tip

You can easily track the KPIs that the Power BI reports display against your business objectives. To learn more, go to Track your business KPIs with Power BI metrics.

Learn more in Power BI Inventory Valuation app.

Reports in the Power BI Projects app

The following table describes how you can use each report in the Power BI Projects app.

To...Open in Business Central (CTRL+select)Learn more
Get a high-level view of your organization's projects. View key metrics and track performance across them.Project OverviewAbout Projects Overview
View all projects and their tasks along with their costs and prices.Project TasksAbout Project Tasks
Analyze the profit of each job and ensure you meet targets.Project ProfitabilityProject Profitability (Power BI Report)
View project completion statistics.Project RealizationAbout Projects Realization
Track the performance of each project and how they track toward their budget.Project Performance to BudgetAbout Projects Performance to Budget
View all sales entries for projects broken down by the sales line type.Project Invoiced Sales by TypeAbout Projects Invoiced Sales by Type
Analyze key sales information on projects based on the customers you sell to the most.Project Invoiced Sales by CustomerAbout Projects Invoiced Sales by Customer
Analyze the schedules of each project task with a Gantt chart, detailing project tasks and their durations.Project TimelineAbout Project Timeline

Tip

You can easily track the KPIs that the Power BI reports display against your business objectives. To learn more, go to Track your business KPIs with Power BI metrics.

Learn more in Power BI Projects app.

Reports in the Power BI Manufacturing app

The following table describes how you can use the reports in the Power BI Manufacturing app.

To...Open in Business Central (CTRL+select)Learn more
Gain insights into work center load and capacity and find bottlenecks and balance production across work centers.Work Center LoadAbout Work Center Load
Gain insights into machine center load and capacity and find bottlenecks and balance production across work centers.Machine Center LoadAbout Machine Center Load
Track allocated hours for each work center to understand workloads.Allocated HoursAbout Allocated Hours
Monitor expected capacity based on production orders to plan for future capacity needs.Expected Capacity NeedAbout Expected Capacity Need
Analyze finished production orders by item and work centers and gain insights into important metrics of production orders.Finished Production Order BreakdownAbout Finished Production Order Breakdown
Track consumption variance for each item and production order and improve production efficiency.Consumption VarianceAbout Consumption Variance
Analyze capacity variance for each work center and production order and identify capacity constraints.Capacity VarianceAbout Capacity Variance
Monitor average production times for each item and work center to improve your production planning.Average Production TimesAbout Average Production Times
Analyze released production orders by item, work center, and time period so you ensure they complete on time.Released Production OrdersAbout Released Production Orders
Track production scrap by production order, source item, work center, and machine center to identify production waste and reduce costs.Production ScrapAbout Production Scrap
Analyze your organization's production order activities. Track production order completion rates, compare planned versus finished output, and monitor actual versus expected and standard costs.Production Order OverviewAbout Production Order Overview
Evaluate efficiency, optimize resource utilization, and improve production outcomes across all work centers. Use KPI summaries and detailed statistics to make data-driven decisions that enhance operational performance.Work Center StatisticsAbout Work Center Statistics
Evaluate efficiency, optimize resource utilization, and improve production outcomes across all machine centers. Use KPI summaries and detailed statistics to make data-driven decisions that enhance operational performance.Machine Center StatisticsAbout Machine Center Statistics
Analyze current production orders, track key metrics like costs and order counts, and monitor planned versus finished outputs.Prod Order - ListAbout Prod Order - List
Track production tasks and sequence operations across machine and work centers, while keeping an eye on planned durations for efficient monitoringProd Order Routing GanttAbout Prod Order Routing Gantt
Analyze work-in-progress inventory through a timeline of ending balance values and a detailed table of production order-related valuations.Production Order WIPAbout Production Order WIP

Tip

You can easily track the KPIs that the Power BI reports display against your business objectives. To learn more, go to Track your business KPIs with Power BI metrics.

Learn more in Power BI Manufacturing app.

Reports in the Power BI Sustainability app

To...Open in Business Central (CTRL+select)Learn more
Explore CO2e effects across business factors. The view is organized by CO2e month on month and category.https://businesscentral.dynamics.com?page=6299CO2e Analysis (Power BI Report)
Review CO2e emissions across multiple factors in an interactive tree structure. Identify key factors that contribute to your overall emissions.https://businesscentral.dynamics.com?page=6303Co2e Decomposition Tree (Power BI Report)
Identify the primary influences that affect your CO2e emissions.https://businesscentral.dynamics.com?page=6304Co2e Key Influences (Power BI Report)
Identify key account categories that are tracking high emissions to understand where to make changes.https://businesscentral.dynamics.com?page=6305Emissions by Category and Scope (Power BI Report)
Find out where you can reduce key carbon emissions and use of renewable energy.https://businesscentral.dynamics.com?page=6317Journey to Net Zero Carbon (Power BI Report)
Ensure you're progressing toward emissions goals by comparing your actual emissions to a baseline.https://businesscentral.dynamics.com?page=6306Realized Emissions vs Baseline (Power BI Report)
Evaluate your carbon footprint against your predefined targets.https://businesscentral.dynamics.com?page=6277Realized Emissions vs Target (Power BI Report)
Explore key metrics for employee absences, gender distributions, activities, qualifications, and union memberships.https://businesscentral.dynamics.com?page=6278Social Analysis (Power BI Report)
Understand how your organization is tracking toward your sustainability goals, and where to make changes around emissions.https://businesscentral.dynamics.com?page=6279Sustainability Overview (Power BI Report)
Analyze your organizations use of water and waste at each facility and location.https://businesscentral.dynamics.com?page=6319Water and Waste Analysis (Power BI Report)

Learn more in Sustainability Power BI app.

Reports in the Power BI Subscription Billing app

To...Open in Business Central (CTRL+select)Learn more
Monitor subscription performance to ensure predictable growth and long-term customer value.https://businesscentral.dynamics.com?page=8110Subscription Billing Overview (Power BI Report)
Gain insight into growth trends and areas for improvement by comparing monthly recurring revenue for different time periods to the same period in the previous year.https://businesscentral.dynamics.com?page=8107Revenue Year-Over-Year (Power BI Report)
Understand what’s driving monthly recurring revenue in your subscription business, and why.https://businesscentral.dynamics.com?page=8103Revenue Analysis (Power BI Report)
Explore how monthly recurring revenue changes over time.https://businesscentral.dynamics.com?page=8106Revenue Development (Power BI Report)
Understand what’s driving monthly recurring revenue churn in your subscription business, and why.https://businesscentral.dynamics.com?page=8098Churn Analysis (Power BI Report)
Identify the products that contribute most to recurring income and how profitable these products are.https://businesscentral.dynamics.com?page=8105Revenue by Item (Power BI Report)
Identify the customers that contribute the most to recurring income and how profitable each customer relationship is.https://businesscentral.dynamics.com?page=8104Revenue by Customer (Power BI Report)
Evaluate sales performance, recurring profitability, and churn impact at an individual salesperson level.https://businesscentral.dynamics.com?page=8102Revenue by Salesperson (Power BI Report)
Assess subscription portfolio growth, customer activity trends, and overall contract value performance across fiscal periods.https://businesscentral.dynamics.com?page=8100Total Contract Value Year-Over-Year (Power BI Report)
Understand what’s driving total contract value in your subscription business, and why.https://businesscentral.dynamics.com?page=8099Total Contract Value Analysis (Power BI Report)
Track deferral balances and recognition schedules to understand the timing of future revenue and ensure accurate financial reporting of your subscription-based liabilities.https://businesscentral.dynamics.com?page=8112Customer Deferrals (Power BI Report)
Track deferral balances and recognition schedules to understand the timing of future expenses and ensure accurate financial reporting of your subscription-based assets.https://businesscentral.dynamics.com?page=8111Vendor Deferrals (Power BI Report)
Forecast monthly recurring revenue and monthly recurring cost to explore your expected financial trajectory and the long-term profitability of your subscription contracts.https://businesscentral.dynamics.com?page=8108Sales and Cost Forecast (Power BI Report)
Forecast future invoicing activity based on the specific billing rhythms defined in your subscriptions to get a cash-flow-oriented view of upcoming billing for customers and vendors.https://businesscentral.dynamics.com?page=8097Billing Schedule (Power BI Report)

Learn more in Power BI Subscription Billing app.

Install Power BI apps for Business Central
Power BI apps FAQ
Track KPIs with Power BI metrics
Introduction to Business Central and Power BI
Work with Power BI reports

Find free e-learning modules for Business Central here