---
id: video/5RJ3yZ7m1UU
type: video
title: "What's New: Financial Analytics (2024 release wave 2)"
summary: "Financial analytics additions in Business Central 2024 release wave 2: a Power BI finance app with 14 reports, 17 financial reporting templates (5 row, 12 column definitions), three new fixed assets Excel reports plus one consolidation Excel report, ad hoc fixed assets analysis, and new documentation. Three demo data sets are planned for the second minor release."
tier: official
language: en
tags:
  - power bi reports
  - financial reporting templates
  - excel reports
  - fixed assets analysis
  - ad hoc analysis
  - demo data
  - column definitions
  - drill-through
  - kpis
  - financial analytics
system: reporting
review:
  state: reviewed
  by: opus
  at: "2026-10-07T23:06:01.677Z"
  flags: []
generated:
  at: "2026-10-07T23:06:01.718Z"
  pipeline: 0.2.0
  prompts:
    extract-video: 1
    summarize-video: 2
  input_hash: 3364be667720546d73734ea55daca7ed2fd9ecf762f5395dde49b9dd137f990c
evidence:
  - kind: video
    url: https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=16s
    title: "What's New: Financial Analytics (2024 release wave 2)"
    date: "2024-10-08T15:00:05.000Z"
    commit: null
    t: 16
    quote: there are 14 new powerbi reports for the finance area through powerbi eded reports
  - kind: video
    url: https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=31s
    title: "What's New: Financial Analytics (2024 release wave 2)"
    date: "2024-10-08T15:00:05.000Z"
    commit: null
    t: 31
    quote: there are 17 new templates five rows 12 columns in the financial reporting module
  - kind: video
    url: https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=51s
    title: "What's New: Financial Analytics (2024 release wave 2)"
    date: "2024-10-08T15:00:05.000Z"
    commit: null
    t: 51
    quote: hopefully soon in the second minor uh in this release we will have new data to better demonstrate some of these new reporting capabilities
  - kind: video
    url: https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=109s
    title: "What's New: Financial Analytics (2024 release wave 2)"
    date: "2024-10-08T15:00:05.000Z"
    commit: null
    t: 109
    quote: have templates for financial reporting uh five row definition which is basically the reports like balance sheet and income statement and we have
  - kind: video
    url: https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=341s
    title: "What's New: Financial Analytics (2024 release wave 2)"
    date: "2024-10-08T15:00:05.000Z"
    commit: null
    t: 341
    quote: compare year to dat or prior Year year-to date or same period last year there's there's these different uh 12 different um column definition
  - kind: video
    url: https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=418s
    title: "What's New: Financial Analytics (2024 release wave 2)"
    date: "2024-10-08T15:00:05.000Z"
    commit: null
    t: 418
    quote: you have three new reports for fixed assets and one new report for consolidation
  - kind: video
    url: https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=730s
    title: "What's New: Financial Analytics (2024 release wave 2)"
    date: "2024-10-08T15:00:05.000Z"
    commit: null
    t: 730
    quote: for the second minor in this release we're going to provide three new demo datas sets one for financial reporting it will have three
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
video_id: 5RJ3yZ7m1UU
channel: yt-microsoft
source_name: Microsoft Dynamics 365 Business Central (YouTube)
url: https://www.youtube.com/watch?v=5RJ3yZ7m1UU
published_at: "2024-10-08T15:00:05.000Z"
duration_s: 855
captions: full
audience:
  - functional consultant
  - administrator
  - partner
  - end user
chapters:
  - t: 0
    title: Overview of Financial Analytics Features
  - t: 67
    title: Power BI Reports and Financial Reporting Templates
  - t: 149
    title: Exploring Power BI Reports in Business Central
  - t: 281
    title: Financial Reporting Templates and Column Definitions
  - t: 401
    title: Excel Reports for Fixed Assets and Documentation
  - t: 490
    title: Fixed Assets Analysis and Ad Hoc Analysis
  - t: 628
    title: Learning Resources and Documentation
  - t: 710
    title: New Demo Data Sets for Financial Analytics
features:
  - name: Power BI Finance App
    status: unclear
    t: 16
    verified: false
    status_source: video
  - name: Financial Reporting Templates
    status: unclear
    t: 109
    verified: false
    status_source: video
  - name: Excel Reports for Fixed Assets
    status: unclear
    t: 401
    verified: false
    status_source: video
  - name: Ad Hoc Analysis for Fixed Assets
    status: unclear
    t: 550
    verified: false
    status_source: video
  - name: Financial Analytics Documentation
    status: unclear
    t: 458
    verified: false
    status_source: video
  - name: New Demo Data Sets
    status: unclear
    t: 710
    verified: false
    status_source: video
objects_mentioned:
  - query analyze fixed assets
  - table fixed assets Ledger entries
  - table Ledger entries
  - table customer Ledger entries
  - table general ledger entries
quotes:
  - t: 16
    text: there are 14 new powerbi reports for the finance area through powerbi eded reports
    check: exact
  - t: 31
    text: there are 17 new templates five rows 12 columns in the financial reporting module
    check: exact
  - t: 51
    text: hopefully soon in the second minor uh in this release we will have new data to better demonstrate some of these new reporting capabilities
    check: exact
  - t: 109
    text: have templates for financial reporting uh five row definition which is basically the reports like balance sheet and income statement and we have
    check: fuzzy
  - t: 341
    text: compare year to dat or prior Year year-to date or same period last year there's there's these different uh 12 different um column definition
    check: snapped
  - t: 418
    text: you have three new reports for fixed assets and one new report for consolidation
    check: exact
  - t: 730
    text: for the second minor in this release we're going to provide three new demo datas sets one for financial reporting it will have three
    check: exact
---

# What's New: Financial Analytics (2024 release wave 2)

> Financial analytics additions in Business Central 2024 release wave 2: a Power BI finance app with 14 reports, 17 financial reporting templates (5 row, 12 column definitions), three new fixed assets Excel reports plus one consolidation Excel report, ad hoc fixed assets analysis, and new documentation. Three demo data sets are planned for the second minor release.

[Watch on YouTube](https://www.youtube.com/watch?v=5RJ3yZ7m1UU) · Microsoft Dynamics 365 Business Central (YouTube) · 2024-10-08 · 14:15 · tier official · reviewed (checked by Opus)

## Overview

The video, published 2024-10-08, walks through the financial analytics changes in the 2024 release wave 2. It demos the Power BI finance app, the financial reporting templates with their row and column definitions, the Excel reports for fixed assets, and the ad hoc analysis view for fixed assets.

It also points to new documentation on financial reporting and analytics. The speaker says three new demo data sets, for financial reporting, fixed assets and projects, will come in the second minor release to better show these reporting capabilities.

## Key points

- The Power BI finance app has 14 reports, with overview pages and KPI pages that drill through to ledger entries for validation and investigation. It is one of six new Power BI apps.
- The financial reporting module gets 17 templates: five row definitions (such as balance sheet and income statement, plus a trial balance) and 12 column definitions (such as year to date, prior year, same period last year). Rows and columns can be mixed and matched.
- Setting up the financial reporting module requires some mapping, and the docs explain how.
- Three new Excel reports cover fixed assets: analysis (which also covers book value), projected value, and details. One new Excel report for consolidation is also added.
- Ad hoc analysis for fixed assets is a query-based view that combines fixed asset table data with multiple dimensions and dates. It supports custom reports and Copilot-assisted report generation.
- New documentation covers the financial reporting overview, performing analytics in Business Central, module setup, and step-by-step creation of row and column definitions.
- Three demo data sets (financial reporting, fixed assets, projects) are expected in the second minor release of this wave.

## Chapters

- [0:00](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=0s) Overview of Financial Analytics Features
- [1:07](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=67s) Power BI Reports and Financial Reporting Templates
- [2:29](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=149s) Exploring Power BI Reports in Business Central
- [4:41](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=281s) Financial Reporting Templates and Column Definitions
- [6:41](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=401s) Excel Reports for Fixed Assets and Documentation
- [8:10](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=490s) Fixed Assets Analysis and Ad Hoc Analysis
- [10:28](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=628s) Learning Resources and Documentation
- [11:50](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=710s) New Demo Data Sets for Financial Analytics

## Features

| Feature | Status | At |
|---|---|---|
| Power BI Finance App | status not stated, demoed | [0:16](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=16s) |
| Financial Reporting Templates | status not stated, demoed | [1:49](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=109s) |
| Excel Reports for Fixed Assets | status not stated, demoed | [6:41](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=401s) |
| Ad Hoc Analysis for Fixed Assets | status not stated, demoed | [9:10](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=550s) |
| Financial Analytics Documentation | status not stated | [7:38](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=458s) |
| New Demo Data Sets | status not stated | [11:50](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=710s) |

## AL objects mentioned

As heard in the captions. A name that matches one object page by exact type and name links to it; the others stay as named.

- query "analyze fixed assets" at [9:10](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=550s)
- table "fixed assets Ledger entries" at [6:58](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=418s)
- table "Ledger entries" at [1:28](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=88s)
- table "customer Ledger entries" at [4:41](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=281s)
- table "general ledger entries" at [4:41](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=281s)

Not found in BC28-30: query "analyze fixed assets", table "fixed assets Ledger entries", table "Ledger entries", table "customer Ledger entries", table "general ledger entries".

## Quotes

- [0:16](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=16s) "there are 14 new powerbi reports for the finance area through powerbi eded reports"
- [0:31](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=31s) "there are 17 new templates five rows 12 columns in the financial reporting module"
- [0:51](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=51s) "hopefully soon in the second minor uh in this release we will have new data to better demonstrate some of these new reporting capabilities"
- [1:49](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=109s) "have templates for financial reporting uh five row definition which is basically the reports like balance sheet and income statement and we have"
- [5:41](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=341s) "compare year to dat or prior Year year-to date or same period last year there's there's these different uh 12 different um column definition"
- [6:58](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=418s) "you have three new reports for fixed assets and one new report for consolidation"
- [12:10](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=730s) "for the second minor in this release we're going to provide three new demo datas sets one for financial reporting it will have three"

## Disclaimers in the video

- [0:51](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=51s) coming-later: hopefully soon in the second minor uh in this release we will have new data to better demonstrate some of these new reporting capabilities
- [12:10](https://www.youtube.com/watch?v=5RJ3yZ7m1UU&t=730s) coming-later: for the second minor in this release we're going to provide three new demo datas sets

Presenters (as heard): Brian nson.