---
id: topic/business-central/business-functionality/finance/financial-analytics/power-bi-finance-app
type: topic
title: Power BI finance app
summary: "The Power BI finance app section covers the embedded Finance Power BI app in Business Central: its setup, semantic model, KPI definitions, and individual reports. It answers questions about receivables, payables, profitability, liquidity, liabilities, budgets, and ledger entry analysis."
tier: official
language: en
system: finance
review:
  state: reviewed
  by: opus
  at: "2026-10-07T02:17:17.993Z"
  flags: []
generated:
  at: "2026-10-08T06:31:25.130Z"
  pipeline: 0.2.0
  prompts:
    hub-topic: 1
  input_hash: 0f33b5e48973fb0adcbe7e75f702ee874aaca00b37cc27f6046c0e47700dc456
evidence:
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-aged-payables-back-dating
    title: Aged Payables (Back Dating)
    date: "2024-10-31"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-aged-receivables-back-dating
    title: Aged Receivables (Back Dating)
    date: "2024-10-31"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-average-collection-period
    title: Average Collection Period
    date: "2025-12-17"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-balance-sheet
    title: Balance Sheet by Month
    date: "2024-10-31"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-budget-comparison
    title: Budget Comparison
    date: "2024-10-31"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-detailed-customer-ledger-entries
    title: Detailed Customer Ledger Entries (Power BI report)
    date: "2024-10-31"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-detailed-vendor-ledger-entries
    title: Detailed Vendor Ledger Entries
    date: "2024-10-31"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-ebitda
    title: EBITDA
    date: "2024-10-31"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-kpis
    title: Finance App KPIs and measures (Power BI)
    date: "2024-10-31"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-app
    title: Finance Power BI app
    date: "2026-06-17"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-financial-overview
    title: Financial Overview
    date: "2024-10-31"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-general-ledger-entries
    title: General Ledger Entries
    date: "2024-10-31"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-income-statement
    title: Income Statement by Month
    date: "2024-10-31"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-late-payment-analysis-receivables
    title: Late Payments (Receivables)
    date: "2025-09-30"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-liabilities
    title: Liabilities
    date: "2024-10-31"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-liquidity
    title: Liquidity
    date: "2024-10-31"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-app-semantic-model
    title: Power BI Finance app semantic model
    date: "2026-07-03"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-profitability
    title: Profitability
    date: "2024-10-31"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-app-setup
    title: Set up the Finance Power BI app
    date: "2026-08-10"
    commit: null
    t: null
    quote: null
links:
  learn:
    - https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-aged-payables-back-dating
    - https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-aged-receivables-back-dating
    - https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-average-collection-period
    - https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-balance-sheet
    - https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-budget-comparison
    - https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-detailed-customer-ledger-entries
    - https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-detailed-vendor-ledger-entries
    - https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-ebitda
    - https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-kpis
    - https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-app
    - https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-financial-overview
    - https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-general-ledger-entries
    - https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-income-statement
    - https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-late-payment-analysis-receivables
    - https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-liabilities
    - https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-liquidity
    - https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-app-semantic-model
    - https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-profitability
    - https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-app-setup
  objects:
    - object/page/36961
    - object/page/36984
    - object/page/36985
    - object/page/36986
    - object/page/36987
    - object/page/36988
    - object/page/36989
    - object/page/36990
    - object/page/36991
    - object/page/36992
    - object/page/36993
    - object/page/36994
    - object/page/36995
    - object/page/36996
    - object/page/36997
    - object/page/37059
    - object/page/37113
  features: []
  topics:
    - topic/business-central/business-functionality/finance/financial-analytics
  localizations: []
  videos:
    - video/5RJ3yZ7m1UU
  posts: []
  guidelines: []
  changes:
    - change/bcapps/10159
learn_toc_path:
  - Business functionality
  - Finance
  - Financial analytics
  - Power BI finance app
toc_file: business-central/TOC.md
parent: topic/business-central/business-functionality/finance/financial-analytics
children: []
coverage:
  learn: 19
  code: 17
  video: 1
  blog: 0
  guideline: 0
bc_forms:
  - 36961
  - 36984
  - 36985
  - 36986
  - 36987
  - 36988
  - 36989
  - 36990
  - 36991
  - 36992
  - 36993
  - 36994
  - 36995
  - 36996
  - 36997
  - 37059
  - 37113
member_hash: 75089a8e7ff70ab091533be01769f296dffb974a54281d80f8800fdd1dd16381
narrative: generated
---

# Power BI finance app

> The Power BI finance app section covers the embedded Finance Power BI app in Business Central: its setup, semantic model, KPI definitions, and individual reports. It answers questions about receivables, payables, profitability, liquidity, liabilities, budgets, and ledger entry analysis.

Path: [Business functionality](../../../business-functionality.md) > [Finance](../../finance.md) > [Financial analytics](../financial-analytics.md) > Power BI finance app · tier official · system finance · narrative reviewed (checked by Opus)

## Overview

The Finance Power BI app embeds Power BI reports in Business Central so finance data can be analyzed without leaving the application. Reports are aimed at three audiences: executives (KPI dashboards), managers (detailed analysis) and finance staff (operational and ledger-level reports).

Start with "Finance Power BI app" for the overview, then "Set up the Finance Power BI app" to configure G/L account categories, map them to the semantic model categories, and set date filters. The "Power BI Finance app semantic model" page describes the star schema, and "Finance App KPIs and measures" documents the calculations and data sources.

The remaining pages each describe one report. They group into receivables and payables (Aged Receivables, Aged Payables, Average Collection Period, Late Payments), financial statements and performance (Balance Sheet by Month, Income Statement by Month, Budget Comparison, Profitability, EBITDA, Financial Overview), balance sheet health (Liquidity, Liabilities), and detailed ledger entries (General Ledger, Customer, Vendor).

## Key points

- Setup involves configuring G/L account categories and subcategories, mapping them to Power BI semantic model categories, and configuring date filters for performance.
- The semantic model is a star schema: fact tables for customer ledger, vendor ledger, G/L and budget entries, plus dimension tables for accounts, customers, vendors and budgets.
- The KPIs and measures reference covers Activity, Balance Sheet, Income Statement, Liquidity, Profitability and Customer Ledger measures.
- Aged Receivables and Aged Payables (Back Dating) use customizable aging periods and payment terms to prioritize collections and vendor payments.
- Late Payments (Receivables) reports Late Payment Amount, Late Payment %, Average Days Late, and number of payments and late payments.
- Balance Sheet by Month and Income Statement by Month give month-to-month hierarchical views with drill-through to ledger entries.
- Liquidity (current, quick, cash ratio) and Liabilities (debt ratio, debt-to-equity) assess short-term health and leverage.
- Detailed Customer, Vendor and General Ledger Entries reports support reconciliation, month-end closing and audits.

## Learn pages

- [Aged Payables (Back Dating)](https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-aged-payables-back-dating): The Aged Payables (Back Dating) report provides an overview of outstanding vendor invoices categorized by payment terms and grouped into aging buckets.
- [Aged Receivables (Back Dating)](https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-aged-receivables-back-dating): The Aged Receivables (Back Dating) report provides an overview of outstanding customer invoices categorized by payment terms and grouped into aging buckets.
- [Average Collection Period](https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-average-collection-period): The Average Collection Period report provides a snapshot of the average number of days that were required to collect account receivable payments.
- [Balance Sheet by Month](https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-balance-sheet): The Balance Sheet by Month report provides a month-to-month view of the balance at date for all balance sheet accounts.
- [Budget Comparison](https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-budget-comparison): The Budget Comparison report provides a comparative analysis of G/L amounts to G/L budget amounts by month.
- [Detailed Customer Ledger Entries (Power BI report)](https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-detailed-customer-ledger-entries): The Detailed Customer Ledger Entries report provides a detailed view of individual transactions from the Detailed Customer Ledger, enhanced with information from customer ledger entries.
- [Detailed Vendor Ledger Entries](https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-detailed-vendor-ledger-entries): The Detailed Vendor Ledger Entries report provides a detailed view of individual transactions from the Detailed Vendor Ledger, enhanced with information from Vendor Ledger entries.
- [EBITDA](https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-ebitda): The EBITDA report provides an overview of your company's EBIT and EBITDA over time.
- [Finance App KPIs and measures (Power BI)](https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-kpis): Get an overview of all the KPIs and measures in the semantic model for the Finance Power BI app.
- [Finance Power BI app](https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-app): The Power BI Finance app provides comprehensive finance analytics to stakeholders at all levels of organizations.
- [Financial Overview](https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-financial-overview): The Financial Overview report gives a clear picture of your organization's finance activities.
- [General Ledger Entries](https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-general-ledger-entries): The General Ledger Entries report provides a detailed view of individual transactions within the general ledger.
- [Income Statement by Month](https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-income-statement): The Income Statement by Month report provides a month-to-month view of the net change for all income statement accounts.
- [Late Payments (Receivables)](https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-late-payment-analysis-receivables): The Late Payments (Receivables) report provides insights into the behaviors of late paying customers.
- [Liabilities](https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-liabilities): The Liabilities report provides an overview of all liabilities broken down by current liabilities, payroll liabilities, and long-term liabilities.
- [Liquidity](https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-liquidity): The Liquidity report shows key liquidity metrics used to analyze an organization's ability to meet current liabilities.
- [Power BI Finance app semantic model](https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-app-semantic-model): Learn about the finance tables and fields in the Power BI Finance app semantic model for Business Central reporting and analysis.
- [Profitability](https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-profitability): The Profitability report shows gross and net profits over time.
- [Set up the Finance Power BI app](https://learn.microsoft.com/dynamics365/business-central/finance-powerbi-app-setup): Learn how to set up the Power BI Finance app

## Videos, posts and code changes

Linked by a Haiku matcher with a grounding quote from the item's summary (link/topics.ts); machine-generated.

- [#10159 Warn when missing Power BI Account Categories Mappings](../../../../../changes/bcapps/10159.md) (code change): "Detects missing Power BI Account Categories mappings. Shows a warning on the PowerBI Reports Setup page"
- [What's New: Financial Analytics (2024 release wave 2)](../../../../../videos/5RJ3yZ7m1UU.md) (video): "Power BI Finance App; Financial Reporting Templates"

## Business Central pages and reports

The pages, reports and queries this hub's Learn pages name (ms.search.form, API reference), joined to the code by exact object id (data/index/docs-objects.json); a page shows the table it runs on.

- [Page 36961 "Account Categories"](../../../../../objects/page/36961.md) · captioned "Power BI Account Categories" · on [Table 36953 "Account Category"](../../../../../objects/table/36953.md)
- [Page 36984 "Financial Overview"](../../../../../objects/page/36984.md) · captioned "Financial Overview (Power BI)"
- [Page 36985 "Income Statement by Month"](../../../../../objects/page/36985.md) · captioned "Income Statement by Month (Power BI)"
- [Page 36986 "Balance Sheet by Month"](../../../../../objects/page/36986.md) · captioned "Balance Sheet by Month (Power BI)"
- [Page 36987 "Budget Comparison"](../../../../../objects/page/36987.md) · captioned "Budget Comparison (Power BI)"
- [Page 36988 "Liquidity KPIs"](../../../../../objects/page/36988.md) · captioned "Liquidity KPIs (Power BI)"
- [Page 36989 "Profitability"](../../../../../objects/page/36989.md) · captioned "Profitability (Power BI)"
- [Page 36990 "Liabilities"](../../../../../objects/page/36990.md) · captioned "Liabilities (Power BI)"
- [Page 36991 "EBITDA"](../../../../../objects/page/36991.md) · captioned "EBITDA (Power BI)"
- [Page 36992 "Average Collection Period"](../../../../../objects/page/36992.md) · captioned "Average Collection Period (Power BI)"
- [Page 36993 "Aged Receivables (Back Dating)"](../../../../../objects/page/36993.md) · captioned "Aged Receivables (Back Dating) (Power BI)"
- [Page 36994 "Aged Payables (Back Dating)"](../../../../../objects/page/36994.md) · captioned "Aged Payables (Back Dating) (Power BI)"
- [Page 36995 "PowerBI General Ledg. Entries"](../../../../../objects/page/36995.md) · captioned "General Ledger Entries (Power BI)"
- [Page 36996 "Detailed Vendor Ledger Entries"](../../../../../objects/page/36996.md) · captioned "Detailed Vendor Ledger Entries (Power BI)"
- [Page 36997 "Detailed Cust. Ledger Entries"](../../../../../objects/page/36997.md) · captioned "Detailed Cust. Ledger Entries (Power BI)"
- [Page 37059 "Finance Report"](../../../../../objects/page/37059.md) · captioned "Finance Report (Power BI)"
- [Page 37113 "Late Payments (Receivables)"](../../../../../objects/page/37113.md) · captioned "Late Payments (Receivables) (Power BI)"

Source: Microsoft Learn (CC BY 4.0). Descriptions are Learn's own.