Business IntelligenceData integration

Power BI Connector.
Your model in Power BI.

Connect Power BI directly to the Fincorex® model. Use actuals, budget and forecast data in visualizations tailored to the report's audience.

Fincorex® BI screen: dashboard with key KPIs and charts
Features

What does connecting Fincorex® with Power BI give you?

01

Direct connection

The Fincorex® model as a data source for Power BI.

02

Data from the EPM model

Financial and operational results within the model's scope.

03

Scenarios in the report

Actuals, budget and forecast in one view.

04

Power BI visualizations

Trend charts, KPI cards and comparison tables.

05

Financial ratios

Monitoring margin, profitability and liquidity.

06

Business breakdowns

Analysis by company, region and product.

07

Variance analysis

Breaking a difference down into the areas that make it up.

08

Result details

From the aggregated amount to the underlying data.

09

Additional sources

Combining Fincorex® data with other data in Power BI.

Report example

Budget and actuals
on one dashboard.

In a Power BI report, we put actuals and budget from the Fincorex® model side by side. Group revenue is PLN 400k below plan. The regional breakdown shows that the largest variance occurred in the South.

  • Compare actuals with the budget
  • Break down the variance by region
  • Check sales by product
Revenue by region12/2026
RegionBudgetActualsVariance
North4.204.35+0.15
Central4.604.65+0.05
South3.803.20−0.60
Total12.6012.20−0.40

Revenue · PLN m · illustrative data

Result details

From region
to product group.

In the South region, the largest variance is on product A. Its sales were PLN 450k below plan, which is 75% of the region's gap.

South · PLN mBudgetActualsVariance
Product A1.801.35−0.45
Product B1.201.10−0.10
Other products0.800.75−0.05
Total3.803.20−0.60
↗

The breakdown shows which products to start with when analyzing the causes of lower sales.

Use cases

From the EPM model to a Power BI dashboard.

⇄

Select data

Define the items, periods and scenarios the report needs.

Model / Scope

◷

Connect the model

Use the connector to make Fincorex® data available in Power BI.

Fincorex / Connector

☷

Build the report

Choose charts, filters and breakdowns for the report's audience.

Power BI / Visualizations

Combining sources

Combine financial results
with sales data.

In Power BI you can put revenue and margin from the Fincorex® model alongside volume from the sales system. In this example, the data is joined by product and period.

Financial data

Revenue, costs and margin.

Operational data

Volumes and sales breakdowns.

Shared periods

A consistent scope for reports and comparisons.

Join keys

A shared product and reporting period identifier.

Sales and margin · South12/2026
ProductUnitsRevenueMargin
A9001.35m24%
B1,1001.10m30%
Other7500.75m26%

Revenue in PLN · illustrative data

Business Intelligence

Explore our other BI solutions.

Management dashboards

See the solution →

Ratio analysis

See the solution →
FAQ

Frequently asked questions about Power BI Connector.

What does Power BI Connector connect?

It connects Power BI directly to the Fincorex® model. Actuals, budget and forecast data reach Power BI without manual exports.

Can I show actuals and budget in one report?

Yes. Actuals, budget and forecast from the Fincorex® model can go into one Power BI report, together with a breakdown by region or product.

Can Fincorex® data be combined with other sources?

Yes. In Power BI you can combine Fincorex® data with other organizational data, e.g. volume from the sales system, and build your own dashboards.

Where is the report built?

In Power BI. Fincorex® is the data source, and you choose the charts, filters and breakdowns in Power BI for the report's audience.

Is the data in Power BI up to date?

Yes. The connector makes Fincorex® data available in real time, without manual exports, so the Power BI report uses current model data.

Can existing Power BI reports be moved to Fincorex® BI?

Yes. Fincorex® BI supports automatic conversion of Power BI reports, so you don't have to rebuild them from scratch.

How long does a Fincorex® BI implementation take?

It depends on the number of data sources and the reporting scope. The first reports and dashboards can be up and running within a few weeks – we'll agree on the details at a meeting.

See your model
before you decide.

As a proof of concept, we’ll rebuild your reporting or planning model in Fincorex® and show it to you at our next meeting.

Book a demo