Skip to content
Bitta Apps

Bitta Sheets · Part 25 · 2:47 · YouTube

Business Central Financial Metrics and Report API for BI

What this video covers

Use financial report metrics in Business Central: numbers that don't live on a G/L account, such as overdue receivables or open sales orders, in your financial reports and workbooks.

Test a metric for a period, add metric rows to a row definition, and insert a metric in a workbook as a live formula.

Then set up the Financial Report API: ready-made addresses and Power Query code for Power BI or Excel, and snapshots for fast scheduled refreshes.

Transcript

Priya wants overdue receivables in the monthly report, and the income statement in Power BI. Here's how to use financial report metrics, and the Financial Report API.

Metrics are numbers that don't live on a G/L account, like open sales orders or overdue receivables. Financial report rows can read them. Financial Report Metrics is the library.

Load Standard Metrics adds twenty, from posted sales invoices to headcount. Each metric reads a table and a field, with a method such as a sum or a count. Copy Metric makes your own version, for example with another filter. Test calculates a metric for a period.

Overdue receivables for 2026 come to 102,438, from 607 records. Import and Export move metrics to another environment. In a row definition, open Actions and choose Insert Metrics from Library.

Pick a metric, and it's added as a row. Here are three: overdue receivables, active customers and inventory value. Each has the totaling type Metric, with the metric's code. From the same menu, Test Metric Row checks a row,

and Metric Card opens the metric's definition. In a workbook, the Metric button on the Formulas tab inserts a metric as a formula. Active customers needs no period. For customer balances, type the period, here 2026.

The cell holds a Business Central formula, so the number stays live. For Power BI or Excel, start in Studio Setup. The Financial Report API isn't set up yet.

In Financial Report API Setup, choose a default report, here the income statement. API Addresses lists the addresses and the Power Query code to paste into Power BI or Excel.

Snapshots store a report's cells, so scheduled refreshes read them fast. Publish Now calculates one. Schedule sets up a job queue entry. Back in Studio Setup, the Financial Report API is set up.

Use metrics when a report needs numbers beyond the ledger, and the API when your reporting lives in Power BI. That's the series. You'll find this guide, and all the others,

on our website.

More Bitta Sheets videos

All videos

Next step

See Bitta Sheets on your own data