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
    A monitor with a dashboard of bars, lines and a gauge, fed from server, spreadsheet and folder through one shared model
    01

    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.

    02

    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.
    03

    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.

    04

    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.

    Contact

    What'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

    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.