Automate the Power BI report you rebuild from every Excel export
Updated by CompileBI
If a system hands you an Excel export every week and you rebuild the same report from it, CompileBI removes the rebuild. Upload the new export, get a fresh Power BI project planned from that file, and open it in Desktop.
Each report is built from the file in front of it. A column that appears this month gets a place; a column that disappears takes its visuals with it, and the report states what it could not answer rather than showing an empty chart.
Upload a fileHow it works
- 01
Upload the file
Drop an .xlsx of up to 50 MB, or a .csv of up to about 18 MB, into the chat. Every sheet is read: its columns, types, dates, blanks and keys. Add a one-line note if you like, such as who the report is for and what it should help decide.
- 02
The report is planned and built
The engine decides which questions the data can answer, writes a DAX measure for each figure, evaluates every measure two ways and refuses any that disagree, then lays out the pages so nothing overlaps. Two to four minutes on a typical workbook.
- 03
Open it in Power BI Desktop
Where the report comes with a Power BI file (.pbit), download it and double-click it: Power BI Desktop on Windows opens it and loads the data as it opens, and saving it keeps it as a .pbix. Every report also comes as a .pbip project in a .zip, to unzip into a short folder and open the same way. It is your file: edit any visual, add pages, publish it wherever you publish reports.
What you get
- A summary page and drill pages, with date, category and reset controls
- A DAX measure for every figure, checked two ways before the file is handed over
- A .pbip project validated against Microsoft's report schema
- A list of what the report answers and what the data could not support
- Up to ten changes by chat on paid plans, each producing a new version
Questions
Can it refresh an existing Power BI file?
No. Each upload produces a new .pbip. If you keep a published report, open the new project, compare, and copy the pages or measures you want into it.
How long does a build take?
Two to four minutes for a typical workbook. Larger or wider files take longer; a 60,000-row sheet builds in under five.
Is there an API?
Not yet. Uploads go through the chat on the website. Say what you need on the contact page; the engine behind the site already runs as a service.