Power BI

Power BI consultancy that finance directors can trust

Independent Power BI consultancy for UK organisations: a licence mix that matches how people really use reports, semantic models your finance team will defend at board level, ERP and CRM data joined properly, and a straight answer on whether Fabric is worth paying for.

19 yrssenior systems delivery
7finance platforms delivered
39 daysearly on an Oracle to Dynamics migration
£25msaving on a single programme

Delivered for and alongside

ShellBPCapitaBaringaOfgemSmart DCCInsightsFlui TechnologiesExxonMobilVodafoneConstellation SoftwareDeloittePwCEYNational GridElexon

Pro, Premium per user or Fabric capacity: what you actually pay

Microsoft's UK pricing page (checked November 2026) lists Power BI Pro at £10.80 per user per month and Premium per user at £18.50 per user per month, both paid yearly and excluding VAT. Pro is included in Microsoft 365 E5 and Office 365 E5, and those users can step up to Premium per user for £10.80. Microsoft's own guidance is that Premium per user is the cheaper route to Premium features below roughly 250 users, and that it does not provision any Fabric capacity.

Fabric capacity is the other model. F SKUs are bought through Azure, billed per second with a one minute minimum and no commitment, and Microsoft quotes a 40.5 per cent saving for a one year reservation. The threshold that matters is F64: at F64 and above, people with a free licence can read reports, while on anything smaller every viewer still needs Pro or Premium per user. Microsoft's launch pricing put F2 at 0.36 US dollars an hour and F64 at 11.52 US dollars an hour in its US West 2 region; UK South prices appear in the Azure pricing calculator in pounds converted from US dollars. The older Premium per capacity P SKUs are being retired, so any renewal landing now should be modelled on F SKUs.

We build that model for you: author count, reader count, refresh needs and growth, costed over three years. PEF is a basic member of the Microsoft AI Cloud Partner Programme with no Solutions Partner designation and receives no fees or incentives from Microsoft, so the licence mix we recommend is the one that costs you least.

The three ways to license Power BI

Power BI Pro£10.80per user per month, paid yearlyIncluded in Microsoft 365 E5and Office 365 E5 Premium per user£18.50per user per month, paid yearlyCheaper route below roughly 250 usersProvisions no Fabric capacity Fabric capacityF SKUsBought through Azure, billed per second40.5% saving on a one year reservationP SKUs being retired THE F64 LINE Below F64: every viewer still needs Pro or PPU F64 and above: free licence users can read reports UK list prices from Microsoft's pricing page, November 2026, excluding VAT. We cost the mix over three years on your author and reader counts.

Semantic models and governance that end the margin argument

Most Power BI estates fail quietly. Three teams each build their own gross margin measure, the numbers disagree in the board pack, and the finance director stops trusting any of them. The fix is not more reports. It is fewer, better semantic models: a star schema per subject area, measures written once in DAX and reused everywhere, row level security that mirrors the organisation chart, and a reconciliation back to the general ledger that is rerun after every refresh.

Governance sits around that. Workspaces split into development, test and production with deployment pipelines between them. A data dictionary that names the owner of every measure. Sensitivity labels on anything that carries payroll or customer data. An endorsement rule so people know which model to build on and which ones are sandboxes. Our data strategy and governance work sets those rules so the Power BI team is not inventing them under deadline pressure.

Copilot in Power BI raises the stakes. Microsoft's documentation requires a paid F2 or larger Fabric capacity or a P1, with trial SKUs excluded, a tenant switch enabled by an administrator, and, for tenants outside the United States and France, an explicit setting allowing data to be processed outside the capacity's region. Copilot answers from your semantic model, so a model with ambiguous names and duplicate measures produces confident, wrong answers. We prepare the model first, then switch Copilot on. Our Microsoft Copilot consultancy covers the governance and adoption side.

Fewer, better semantic models

TODAY Sales team marginFinance team marginOperations margin Three numbersin the board pack One semantic model Star schema per subject areaMeasures written once in DAXRow level security by org chartReconciled to the ledger each refresh Board packFinance reportsCopilot answers Plus sensitivity labels and an endorsement rule, so people know which model to build on.

Before Copilot is switched on

Paid F2+ capacity orP1, no trialsTenant switch on, byan adminCross region settingoutside US and FranceA clean semantic modelfirst

Connecting ERP and CRM data without a warehouse you do not need

Finance reporting lives or dies on the join between the ERP and everything else. We connect Dynamics 365, SAP, Oracle, NetSuite, Sage and Unit4 ledgers to Salesforce, HubSpot or Dynamics 365 Customer Engagement pipelines, and to payroll, so that revenue, cost and headcount are read from the same date table and the same customer key. The hard part is rarely the connector. It is agreeing which system owns the customer, how intercompany eliminations are handled and what the fiscal calendar looks like for each entity. Our ERP integration and CRM integration practices settle those questions before anyone opens Power BI Desktop.

Then the architecture decision. For a single ERP, a few years of history and tens of millions of rows, an import model refreshed overnight with incremental refresh is usually enough and costs nothing beyond licences. A Fabric capacity, a lakehouse or a warehouse earns its keep when you have several source systems with conflicting keys, history that predates the current ERP, near real time needs, or data engineers who need a place to transform data outside the model. OneLake storage is billed on top of capacity once the free mirroring allowance is used, so volumes belong in the business case.

We will tell you plainly if the answer is a well built import model and a tidy DirectQuery for operational screens. A Power BI consultant who recommends a platform before seeing your data volumes is selling, not advising.

The architecture decision

Import model, incremental refreshUsually enough. Costs nothing beyond licences. A single ERPA few years of historyTens of millions of rowsOvernight refresh is fine Fabric capacity, lakehouse or warehouseEarns its keep when you have: Several sources with conflicting keysHistory that predates the current ERPNear real time needsData engineers who transform outside the model

Part A or Part B: how we work on Power BI

There are two ways to bring us in. Part A is independent assurance: we sit alongside your analysts, your systems integrator or your Microsoft partner, review the model design, challenge the licensing proposal, test the numbers against the ledger and report to the finance director rather than to the vendor. Part B is delivery led by our own practitioners, from licence modelling through model build, report design and handover to your team. Many clients take Part A for a troubled estate and Part B for the rebuild.

Our bench is made up of consultants who have led and analysed decisions before, during and after system migrations, which is why we start with the ledger rather than the visuals. Our team has implemented and delivered pretty much every finance system in 19 years, including Oracle, Microsoft Dynamics, NetSuite, Sage, SAP S/4HANA, Unit4 and Access, so we know where the trial balance really sits in each of them and what breaks when a chart of accounts changes mid year.

Report design follows one rule: a finance director should be able to trace any number on a page back to a journal line in under a minute. That means consistent sign conventions, variance columns that are measures rather than hand typed, drill through to transactions, and a page footer that states the refresh time and the source. We also leave behind documentation your team can maintain, because a Power BI estate that depends on us is a failure on our part.

Fees are shown plainly on our pricing page. If you want to talk through a specific estate, contact us and bring the report nobody trusts.

What we have delivered

22m+assets, National Grid separation

Ran the procurement of every software provider on the National Grid separation, more than 22 million assets, through to implementation including Oracle to SAP S/4HANA.

£25msaving at BP Pulse, 39 days early

Delivered the Oracle to Microsoft Dynamics migration at BP Pulse 39 days ahead of forecast, with a £25m saving, the largest on a programme where PEF held the main contract.

£9bnEnergy Bills Support Scheme

Delivered the £9bn Energy Bills Support Scheme for Ofgem, BEIS and HMRC.

19 yrsfinance systems delivery

Implemented and delivered most major finance systems over 19 years: Oracle, Microsoft Dynamics, NetSuite, Sage, SAP S/4HANA, Unit4 and Access.

ERP and CRMpre, mid and post migration

A suite of consultants who have led and analysed pre, mid and post migration decisions and implementations across ERP and CRM platforms, independent of every vendor.

Questions we are asked

How much does Power BI cost in the UK?

On Microsoft's UK pricing page in November 2026, Power BI Pro is £10.80 per user per month and Premium per user is £18.50 per user per month, both paid yearly and excluding VAT. Pro is included in Microsoft 365 E5. Fabric capacity is priced separately through Azure, billed per second, with a one year reservation saving quoted at 40.5 per cent.

Do I need Microsoft Fabric to use Power BI?

No. Power BI Pro and Premium per user licences work without any Fabric capacity, and Premium per user does not provision one. You need an F SKU when you want free licence viewers at F64 and above, Copilot in Power BI, or Fabric workloads such as a lakehouse or warehouse alongside your reports.

Is Copilot in Power BI included with Power BI Pro?

Not on its own. Microsoft's documentation says Copilot in Fabric and Power BI needs a paid F2 or larger capacity or a P1, that trial SKUs are not supported, and that an administrator must enable a tenant setting. Tenants outside the United States and France must also allow data to be processed outside the capacity's region before Copilot works.

What does a Power BI consultant actually do?

A good Power BI consultant models your licensing, designs semantic models that reconcile to the general ledger, connects ERP and CRM data on agreed keys, sets governance for workspaces, security and endorsement, and designs reports that finance directors can trace back to transactions. The poor ones build dashboards from spreadsheets and leave before the first month end disagreement.

Should we choose Power BI Premium per user or a Fabric capacity?

Count authors and readers first. Microsoft says Premium per user is more cost effective for Premium features below about 250 users. If you have a small number of authors and hundreds of readers, an F64 capacity that lets free licence users view content can cost less, and it is the only route to Copilot. We cost both over three years before recommending either.

Want numbers your board will stop questioning?

Tell us what your finance team argues about each month end and we will show you what a fixed Power BI estate looks like.

Book a conversation