Tutorial

Financial Reporting with Business Central Insights

Introduction

Financial reporting in Business Central Insights transforms static statements into interactive insights in Power BI. Your familiar row definitions from Business Central are carried across, so you can analyse Balance Sheets, Income Statements, and Cash Flow with the flexibility to filter, drill down, and slice by company, period, or dimension. With clear visuals, customisable totals, and cross-company analysis, you can move seamlessly from high-level overviews to detailed line-level insights, making reporting faster, clearer, and more actionable.

Financial Statement examples:

You can configure multiple financial statements depending on your needs, the 3 most commonly used financial statements in Power BI are: 

  • Balance Sheet 

  • Income Statement by Dimension 

  • Cash Flow Statement by Month

What features are supported in Power BI?

The following features are currently supported in Power BI:

Row Definitions in Power BI

Our Financial Reporting solution supports Row Definitions from Business Central. These are imported into Power BI and can then be visualised alongside standard financial measures.

Supported Totalling Types:

The totalling type determines which accounts will be totalled, that you specify in the Totalling field.

  • Posting Accounts – Select Posting G/L accounts in the Totalling field.

  • Total Accounts – Select End-Total and Total G/L Accounts in the Totalling field

  • Account Category – Select G/L Account Categories in the Totalling field.

  • Formula – Create custom rows based on logic or filters applied to existing rows. We currently support + and - operations and filter expressions (Note: the characters (, ), *, /, ^, % are not supported in Power BI).

Supported Amount Types:

  • Amount Type = Net Amount – shows the net balance of the account(s) for the period, after debits and credits are applied.

Supported Dimension Totalling / Filters

In Business Central Financial Reporting you can apply additional Dimension filters (or totalling) to each line. In this example NT, SA and QLD areas were chosen to include all dimensions in this range.

  • We support all 4 additional dimension filters in Power BI. 

  • Dimension filters will be automatically applied in Power BI.

You can analyse your financial reports in Power BI by any dimension. Our Power BI apps support all 12 Financial Dimensions, which are configured in the Power BI Insights Connector. https://businesscentralinsights.com/dimension-setup

Together, these options let you build reports that range from detailed transactional breakdowns to high-level financial summaries, depending on what your business needs to see.

Column Definitions and Measures

While column definitions exist in standard Business Central, in Power BI they are represented through measure selection. Instead of pre-defined columns, you can dynamically choose which financial measures to display in your report.

This approach leverages the standard measures already available in Power BI, as shown in the example below where selected measures appear as the columns in the report.

How to create Financial Reports in Business Central

More information about Financial Reporting in Business Central can be found in the Microsoft Learn documentation.

Business Central Insights builds on these capabilities to make financial reporting more accessible and interactive within Power BI.

Example: Create a new Expenses Financial Report in Business Central

We are looking to create a straightforward financial report that displays expenses by different groups. Using our standard Income Statement as a foundation, we can easily adapt and customise it to meet specific reporting requirements.

Step 1: Create new Row Definition

Choose the search 🔎icon, enter (Financial Report) Row Definitions

You can either create a new one, or, as shown in our example, copy an existing Row Definition.

Select Row Definition (copy an existing one, e.g. M-INCOME): choose copy Row Definition then enter ‘EXPENSES’ in the New Row Definition Name

Step 2: Edit Row Definition

Home > Edit Row Definition

On this screen you can remove all irrelevant lines, in our example anything that was not expenses was removed, as well as all lines where the totalling is blank.

Step 3: Create Financial Report 

Now that the row definition is set up, we can create a new financial report by following these steps:

Finance > Financial Reporting > + New > Type Name (e.g. ‘EXPENSES’) > Type Display Title  (e.g. ‘Expenses Analysis’) > Select Row Definition drop-down: EXPENSES

Then in the Column Definition drop-down: M.NETCHANG and choose View Financial Report

Step 4: View the Financial Report in Business Central

Step 5: Refresh the Semantic Model and view in Power BI 

In Power BI, refresh your semantic model. You can do this manually from your workspace, or rely on your scheduled refresh from Business Central. Once refreshed, your new report will be available in Power BI, ready for filtering and analysis.

Then you can view your expenses by Month:

Or view expenses by Area or any other Dimension by selecting the tab in the column list.

Once imported into Power BI, Financial Reports can be analysed by:

  • Time – view reports over months, quarters, or years.

  • Dimensions – filter or group by whichever values your organisation has configured (e.g. Department, Salesperson, Region, Project).

This means the same structures defined in Business Central can be analysed dynamically in Power BI, transforming static financial statements into interactive reports that can be drilled into, filtered, and reused across the organisation.

Note: Each time you change the Financial Reports definition in Business Central, you will have to refresh the semantic model in Power BI to reflect the changes.

Excluding Reports from Power BI

A new field, “Exclude from Power BI”, has been added to the Financial Report screen in Business Central. By selecting this field, you can prevent specific reports from being imported and displayed in Power BI.

This is useful for test or draft reports that should remain internal to Business Central only.

We use cookies

We use cookies to enhance your browsing experience, personalize content and ads, and analyze our traffic. Read our Privacy Policy.