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.