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 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.
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.
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.
.mpp files come out of it exactly as they went in.See them before you buy them
These are the actual report pages, not mock-ups. Every one of them is filtered by project, resource and period, and every one can be edited: the data model, the Power Query steps and the measures are all open. The earned value pages exist because one index on one date decides nothing: one CPI is a number, twelve are a diagnosis.
Home
The summary of the portfolio being analysed: progress, baseline, budget against planned and actual, and how many projects are on schedule, late, completed or still to start. With a single-project export you see that one project, with everything that concerns it.

Portfolio Overview
Adds the detail Home leaves out: planned, scheduled and actual work and cost side by side, the top ten projects by effort, and work and costs broken down by project manager.

Timeline
The Gantt view across projects. Each bar is a project, and you can open a bar to see what is inside it.

Work by Resource
Assignments in detail. The first matrix gives the yearly summary — switchable to quarter, month, week or day — of the hours assigned to each resource by project and task. The second shows assignments month by month, with the hierarchy the other way round: project, then resource, then task.

Resource Workload
A full-page matrix of assigned hours by project, resource and task — the order of resource and project is easy to swap. The column pairs, such as 02-06, are the month and the running week number from the start of the year; that scale can be changed too.

Tasks Cost
Costs by task and by resource, down to the individual line, so a number in the portfolio view can be traced back to the work that produced it.

Milestones and deadlines
Milestone completion dates against their deadlines, across the portfolio. It gives the on-time rate, the average slippage in days and where delays concentrate by milestone type — end of engineering, end of production, end of installation — so a critical date raises a warning before it is missed.

Material & cost resources
All project costs in one view, or filtered to work, material and cost resources separately. Columns break down by month and week, with the year on a slicer.

Resource Loading
Assigned, completed and remaining work per resource and project, and in the matrix the daily picture: work assigned, availability for that day, availability left, and the hours of over-allocation. This is the page where a person booked twice stops being invisible.

Resource Usage
Assigned work against actual work, and assigned cost against actual cost, for every resource — work, material and cost alike — with the peaks of usage visible.

Tasks finishing this week and this month
The operational page: what is due to finish within this week, Sunday included, and within this month. It flags which of those tasks sit on the critical path, so recovery effort — crashing or fast tracking — goes where it changes the end date.

Earned Value, time-phased
Earned value for the imported portfolio with the standard indicators: CPI and SPI by date, CV and SV by date, BAC against EAC. Time-phased means it works on the daily figures of every task, not on a single snapshot.

Earned Value Portfolio
The same analysis lifted to the whole portfolio: one earned value curve for everything you imported, over a period you choose.

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 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 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.
.mpp files: it reads what OneClickExporter has already extracted, which is why nothing here has to be mapped by hand.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.
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
.pbittemplate 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
Prices exclude VAT. Payments are handled by Lemon Squeezy as merchant of record: business invoices and VAT are taken care of at checkout.
What everyone asks
Do my project managers have to change how they work?
Which versions of Microsoft Project does it work with?
.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?
Do I need Power BI?
.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?
.mpp is never modified and never saved by the tool.Does it handle a master plan with a shared resource pool?
Can I build my own pages?
How long does setup take?
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
.mppplans from Microsoft Project desktop — Project itself not required- Power BI Desktop
- Set up in under five minutes