OneClickReport for Power BI

OneClickReport · Microsoft Project into Power BI

Your plans are already full of data. Nobody can see it.

OneClickReport is the Power BI half: fourteen report pages already built, waiting for the data that OneClickExporter pulls out of your plans. Open, refresh, and the portfolio is on screen — without changing how anyone works.

  • Nothing changes for your project managers
  • Set up in under five minutes
The OneClickReport dashboard fed by CSV files flowing in from the export: KPI tiles, cost bars, an allocation donut at 85 per cent and a trend curve, refreshed daily
The problem

The data exists. Getting it out is the job nobody wants.

Every plan in your portfolio holds budget, progress, milestones and workload. Turning that into something a steering committee can read is still done by hand, and by the time it’s ready it’s already old.

Scattered data

Hours spent opening one .mpp after another, hunting for the figure someone asked for.

Manual reporting

Days in Excel and PowerPoint before every executive meeting, rebuilding the same report from scratch.

Resource blindness

No way to see who is over-allocated when the same people sit on several projects at once.

Data already stale

The report is out of date before it reaches the people who are supposed to decide on it.

How it works

Three steps, and none of them is yours to repeat

The plans stay where they are. The dashboard comes to the data, not the other way round. Pointing it at your own folder is a single setting: how to change the data sources of the dashboard.

Keep your plans as they are

Your subprojects stay linked in the Microsoft Project master plan exactly as you built them. Nothing to restructure, nothing to migrate.

One click to extract

OneClickExporter reads the plan, extracts the data and validates it, producing the clean set of files these dashboards are built on.

Open the dashboard

Power BI picks the data up on refresh and the charts are there: portfolio, costs, resources, milestones, earned value.

What you see

Fourteen report pages, already built

You are not handed an empty canvas and a data model. The dashboard arrives finished, organised around the questions a portfolio actually gets asked — and every page is filtered by project, resource and period.

Portfolio

  • HomeProgress, baseline, budget vs planned vs actual, earned value, and how many projects are on schedule, late, future or completed.
  • Portfolio OverviewTop ten projects by effort, plus work and costs broken down by project manager.
  • Portfolio GovernanceThe governance view of the whole portfolio in one table.

Schedule

  • TimelineAn interactive Gantt across projects, with a timeline slicer to move through the period.
  • MilestonesEvery milestone in the portfolio, filterable by project and by type.
  • Tasks ending this week / this monthWhat closes in the next few days, split between tasks that have assignments and tasks that don’t — the ones nobody is watching.

Resources

  • Work by resourceWho is working on what, across projects, with the time-phased breakdown alongside.
  • Resource WorkloadThe load of each person, period by period.
  • Resource UsageWork and cost per resource, with the trend over time.
  • Resource LoadingUsage against availability — the page where over-allocation shows up.
  • Materials & cost resourcesCosts by resource, for material and cost resources as well as people.

Cost and earned value

  • Tasks costCosts by task and by resource, down to the individual line.
  • Earned Value PortfolioThe earned value curve for the whole portfolio, time-phased, with a selectable interval.
  • Earned ValueThe full set per project: CPI and SPI by date, CV and SV by date, BAC against EAC.
It reads your plans, it doesn’t rewrite them. The extraction is read-only: your .mpp files come out of it exactly as they went in.
What you get

Two pieces in the kit: the dashboards, and what you need to build your own

The first is finished work you can put in front of a steering committee tomorrow. The second is what stops the kit from being a dead end the day you need a page nobody wrote.

The dashboards

The OneClickReport template (.pbit)

Fourteen finished report pages, from portfolio governance to time-phased earned value, drawn on a data model that is already wired up. It ships as a clean Power BI template: no data from anyone else inside, just the model and the pages. Open it, point it at your own exports, refresh, and the portfolio is there — nothing to map, nothing to name, no blank report to start from.

The documentation

The Toolkit

The data schema written down: which table holds what, how the tables relate, which measures already exist and how the Power Query steps are put together. It is what you read when you need a page nobody wrote — so the fifteenth report is yours to build, on the same model, instead of a request to somebody else.

And the data? It comes from OneClickExporter, a separate product and a separate licence. OneClickReport does not open .mpp files: it reads what OneClickExporter has already extracted, which is why nothing here has to be mapped by hand.
Why it pays off

The reporting week, given back

The gain isn’t prettier charts. It’s the days that used to disappear into rebuilding them. And the days are not the whole cost: by the time the report is finished, the project has moved on.

85%less time spent preparing the report
100%of transcription errors removed — nothing is retyped
10×faster to compare projects across the portfolio
Price

One kit, everything in it

There are no editions and nothing is held back: the fourteen report pages, the data model behind them and the toolkit for building your own all come in the same licence.

OneClickReport

The Power BI kit for Microsoft Project data

€99one-off, per site

  • The .pbit template with all fourteen report pages
  • Earned Value, time-phased and across the portfolio
  • The Toolkit: the data schema, documented
  • Every measure and Power Query step open and reusable
  • Works with any OneClickExporter licence level
Bought once, yours for good. One payment, one licence for your whole organisation — any number of people can open and work on the file . Nothing renews, nothing expires. The kit is delivered in full at purchase and the price is not refundable, which is why every page of the report is shown above before you buy. Buy OneClickReport
OneClickReport needs data to draw. That data comes from OneClickExporter, which is licensed separately — the dashboards read its files and nothing else has to be configured. If you already own it, this kit is the only thing missing.

Prices exclude VAT. Payments are handled by Lemon Squeezy as merchant of record: business invoices and VAT are taken care of at checkout.

FAQ

What everyone asks

Do my project managers have to change how they work?
No, and that is the point. They carry on in Microsoft Project Desktop exactly as before. OneClickReport reads what they already produce; nobody has to learn a new tool or fill in anything twice.
Which versions of Microsoft Project does it work with?
Plans from Microsoft Project 2016, 2019, 2021 and the desktop versions in general. Project itself does not have to be installed anywhere: OneClickExporter reads the .mpp file directly, so the extraction can run on a machine that has never had Project on it.
How many people does one licence cover?
Everyone in your organisation. The licence is per site, not per seat: any number of colleagues can open the file, refresh the data, change the model, build pages and publish, on one licence. A separate company — even inside the same group — buys its own.
Do I need Power BI?
Yes, for the dashboard: Power BI Desktop is free from Microsoft and opens the .pbit template without a licence. A Power BI Pro licence is only needed if you want to publish the report to the Power BI service and share it online.
Does it change my plans?
No. The extraction is read-only: it opens the plan, reads it and writes its own data files elsewhere. Your .mpp is never modified and never saved by the tool.
Does it handle a master plan with a shared resource pool?
Yes. Linked subprojects and shared resource pools are consolidated by OneClickExporter into one coherent set of data, so a resource working across several projects appears once in the dashboards, with the total load.
Can I build my own pages?
Yes, completely. The data model and the Power Query steps are open and editable, a large set of measures is already defined and ready to reuse, the field names map onto the Microsoft Project fields you already know, and the filters that make each page read correctly are set up for you. So you can restyle a page, build new ones, or add your own tables, aggregations and measures. The starting point is finished; it just isn’t closed.
How long does setup take?
Under five minutes. There is no server to install, no database to provision and no account to create — it is a desktop application and a Power BI template.

Stop rebuilding the report. Start reading it.

Your plans already hold the answers. OneClickReport is the click between them and a dashboard your steering committee can actually use.

  • Windows
  • .mpp plans from Microsoft Project desktop — Project itself not required
  • Power BI Desktop
  • Set up in under five minutes
Scroll to Top