Business Applications
Power BI dashboards with agreed KPIs and access roles.
Power BI reports and dashboards show figures from ERP, apps and files, from month-end close to the daily position. One shared model calculates each KPI once.
For management, controlling and departments who decide with figures from ERP, apps and Excel and want to see the same KPI everywhere.
- Power BI
- Microsoft Fabric
- Copilot in Power BI
- Data gateway
- Dataverse
- Entra ID

The figure for Monday's meeting
Monday, management meeting. Revenue per region is on the dashboard, refreshed from the ERP at six in the morning. The sales manager for the east sees her region, management sees all of them. When someone asks why the contribution margin is below last month, the controller opens the same KPI in the report underneath and follows it down to the individual order.
Model, roles, data freshness
Before a KPI appears in a report, it has a written definition and an owner in the business. We first build one report for a recurring decision, reconcile it with figures your finance team knows, and then extend the model one area at a time. What it involves, depending on where you start:
- Shared data modelTables from the ERP, business applications and Excel files flow into one semantic model with relationships and measures that every report builds on; data from bexio or Abacus arrives through the ERP integration.Result: revenue is calculated the same way in every report, and one correction applies everywhere.
- KPI definitionsWith finance and the business we agree what a KPI counts, which exceptions apply and who owns it; the description sits in the model right next to the formula.Result: anyone who questions a figure finds its definition and its owner.
- Row-level securityRoles in the model filter data by region, cost centre or customer, filled through Entra ID security groups and tested with accounts from each group.Result: the branch manager sees her branch, management sees all of them, in the same report.
- Refresh and gatewayA schedule per source, a data gateway for systems on your own network and an alert to a named person when a run fails; the data timestamp shows on every page.Result: everyone knows how recent the figure is.
- Microsoft Fabric for large data volumesWhen many sources come together, history spans years or queries slow the model down, we prepare the data in a lakehouse or warehouse that Power BI reads from directly.Result: reports stay fast, and data preparation lives in one place.
- Copilot in Power BIBusiness users ask for a figure in a sentence or have a report page summarised; we prepare the model with descriptions, synonyms and verified answers.Result: Copilot answers with the KPIs your finance team has defined.
Definitions and access first
A recurring decision for the first report and the figures used to make it today. Read access to the sources, a person from finance for the definitions and a list of who may see which data. Whether Pro, Premium Per User or a Fabric capacity fits depends on the number of readers, the data volume and Copilot; we settle that at the start.
Reconciled with figures you know
A report in your tenant whose figures your finance team has reconciled with previous analyses for a closed period, differences explained. Roles tested with accounts from each group, and a deliberately broken refresh that reaches the responsible person. Plus a KPI catalogue with definition and owner; monitoring of refreshes can go to our support and operations team.
Sound familiar? Tell us where you stand today.
ContactWhat's new.
As of: 9 October 2026
- As of 15 June 2026
Fabric capacities replace Power BI Premium per capacity.
Microsoft is consolidating purchase options and retiring the Power BI Premium P SKUs; new and existing customers should buy Fabric capacities (F SKUs), which Azure bills per second. Premium Per User remains a per-person licence with Premium features and does not provision a Fabric capacity. From F64, readers with a free licence and the Viewer role can open Power BI content; on smaller capacities every reader needs Pro or Premium Per User.
Source: Microsoft Learn: Microsoft Fabric licenses and capacity - As of 24 August 2026
Copilot in Power BI needs a paid capacity.
Copilot runs on Fabric capacities from F2 or Power BI Premium from P1; trial capacities and a Pro or Premium Per User licence alone are not enough. If the capacity is outside the US and the EU Data Boundary, Copilot is off by default until the Fabric administrator allows processing outside the region. Consumption appears as capacity units in the Capacity Metrics app.
Source: Microsoft Learn: Copilot for Power BI overview - As of 13 May 2026
Row-level security filters for readers only.
Row-level security roles apply only to people with the Viewer role in the workspace; Admin, Member and Contributor see all rows. Roles are defined in Power BI Desktop with DAX and filled in the service with people or Entra ID security groups; Microsoft 365 groups cannot be assigned to a role.
Source: Microsoft Learn: Row-level security with Power BI
Sources, access and the data around it.
Where the figures come from, who may see them and where they go next.
What the service does and when Excel is enough for an analysis.
DataverseData from your apps as a source, with relationships and history.
Dynamics 365When sales or finance run in Microsoft's CRM or ERP.
Entra IDGroups that fill the roles in a report.
Data migrationBring history over from legacy systems before it appears in a report.
Compliance & Data ProtectionPersonal data in reports and sensitivity labels from Microsoft Purview.
Agentic AIAgents that query KPIs from the model and pass them on.
Dashboards already in use.
Campaigns and redemptions at AEW myHome, portfolio, budget and open approvals in the Inselspital research portal, building consumption comparisons at AEW and ERP data in the reports at REV Ritter.

AEW Energie AG
AEW: Tracking campaigns and redemptions in one place
View project
Inselspital, Universitätsspital Bern
Bringing research dossiers and approvals together at Inselspital
View project
AEW Energie AG
Capturing building data on site and reviewing it together at AEW
View project
REV Ritter GmbH
Connecting documents, information and business processes at REV Ritter
View projectRelated to your task
Customers, orders and invoices from bexio or Abacus as a source for your reports.
Business appsApps that capture data on site for analysis on the dashboard.
Process automationWhen a KPI should trigger a workflow, such as an alert at a threshold.
Power Platform governanceEnvironments, data policies and a licence overview for Power BI and the rest of the platform.
Support & OperationsHave refreshes and gateways monitored after handover.
What finance and management ask before the first dashboard.
Pro, Premium Per User or a Fabric capacity?
Anyone who creates and shares reports needs Pro or Premium Per User. In Pro workspaces only people with their own licence can read; if the report sits on a Fabric capacity from F64, a free licence is enough for readers. Premium Per User brings Premium features to a smaller group; lakehouse and warehouse need a Fabric capacity, Copilot a paid capacity. We work it through with your number of creators and readers.
What happens to our Excel analyses?
They stay where they work well. With Analyze in Excel, a pivot table connects directly to the model, with the same KPIs and the same roles as the report. Excel files that serve as a source today we connect from SharePoint, so a changed file shows up in the report at the next refresh.
How current are the figures?
As current as the decision requires. Most reports load their data on a schedule; on shared capacity Microsoft allows fewer scheduled refreshes per day than with Premium Per User or a Fabric capacity. Where the daily position is not enough, the model queries the source directly. Every page shows how recent the data is.
Who sees which figures?
Row-level security in the model decides that, for example by region or cost centre. It only applies to people who read the report: anyone allowed to edit in the workspace sees all data. So we distribute reports through an app or the Viewer role and fill the roles with Entra ID security groups your IT already maintains.
Do we need Microsoft Fabric?
For many reports, no. A Power BI model that imports its data carries most finance and sales analyses. Fabric pays off when many sources come together, history grows long, several teams use the same prepared data or Copilot is to be added. Then we prepare the data once in a lakehouse, and the reports read from there.
What can Copilot in Power BI do, and what does it need?
Copilot summarises report pages, answers questions about the data and helps build pages and DAX formulas. It needs a paid capacity and approval from the Fabric administrator; if the capacity is outside the US and the EU Data Boundary, also permission to process data outside the region. It gives good answers once KPIs are described and clearly named.
Agree on a useful next step
Tell us about your current workflow, the systems involved and the result you need. In our first conversation, we identify what else we need to know to plan a useful next step.
