Excel to Power BI, without building the report by hand
Updated by CompileBI
CompileBI turns an Excel workbook into a Power BI project you can open and edit. You upload the .xlsx, the engine reads every sheet, plans the questions the data can answer, writes the measures and lays out the pages, and hands you a .pbip file for Power BI Desktop.
It is not a connector and not a template. Nothing is imported into a fixed layout: the report is planned from what your workbook actually holds, so a sales ledger, a survey export and a budget file come out as three different reports.
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
Do I need Power BI Desktop?
Yes, to open the result. The download is a Power BI file (.pbit) where one was built, and always a .pbip project, Power BI Desktop's own editable format. Desktop is free from Microsoft and runs on Windows.
Does my Excel data get sent to an AI model?
The file itself is not. The model is sent your column and sheet names, counts for each column, the lowest and highest value of each number and date column, the shape of the first few entries with every letter and digit replaced, and the note you wrote; if a sheet has no header row, its first row is read as the column names. Columns we recognise as email, phone, ID, IP address or date of birth are left out, except for their names. The engine's copy of the workbook is deleted when the build ends, and the stored upload 30 days after the build.
What if a column is unusable?
The report says so. Every question the data could not support is listed with the reason, next to the questions it answers.