A Power BI report from Excel, without Copilot
Updated by CompileBI
Copilot in Power BI needs a paid Fabric capacity of F2 or above, or Power BI Premium P1 or above, and it builds report pages on a semantic model. A Power BI Pro licence on its own is not enough. Without that capacity, a report from an Excel workbook comes one of four ways: you build it by hand in Power BI Desktop, you paste the data into a quick report in the Power BI service, you hire someone to build it, or a generator such as CompileBI builds a first version that you then edit.
Building it by hand costs no money: Power BI Desktop is free from Microsoft, and every table, measure and page is your decision. It costs time, and it needs Power Query, data modelling and DAX. A quick report needs only a free Fabric licence and no capacity: you paste up to 512 KB of data into the Power BI service and it generates the visuals for you, but a file cannot be uploaded yet and pasted data cannot be updated later. A freelancer brings a person who asks what the report is for and can tidy messy data first; you pay for their time, and the result and the turnaround depend on who you hire.
CompileBI returns an editable .pbip project in minutes: the model, a DAX measure for every figure and the report pages, planned from your own columns, with no capacity or Copilot involved. The workbook is uploaded to CompileBI, and a summary of its columns, never the file itself, is sent to an AI model on OpenAI's API, so if your organisation keeps data inside its region, check with your admin first. It works only from what the file holds, it does not clean the data for you, and it cannot ask what you meant beyond the one-line note you add. You open the result in Power BI Desktop on Windows (see "How to open a .pbip file and save it as .pbix" under More guides) and change whatever you like.
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
- An editable .pbip project: the model, the DAX measures and the report pages, yours to change
- A DAX measure for every figure, checked two ways before the file is handed over
- A summary page and drill pages, with date, category and reset controls
- A list of what the report answers and what the data could not support
- Nothing to buy from Microsoft to open it: Power BI Desktop is free and runs on Windows 10 or later
Questions
What does Copilot in Power BI need?
A paid Fabric capacity of F2 or above, or Power BI Premium P1 or above. Trial capacities and free SKUs are not supported, and a Power BI Pro or Premium Per User licence alone is not enough, because Copilot runs on the organisation's capacity. In Power BI Desktop you also sign in and need admin, member or contributor access to a workspace on such a capacity with Copilot enabled. An organisation can instead charge Copilot use to a Fabric Copilot capacity, which must itself be at least an F2 or a P1. Sources: the Microsoft Learn pages "Copilot for Power BI overview", "Use Copilot in Power BI Desktop" and "Fabric Copilot Capacity for Usage Billing", read on 30 September 2026.
Is Copilot switched on by default?
Yes, and an admin can turn it off. If the tenant or its capacity is outside the United States or the EU data boundary, Copilot is off by default until a Fabric admin enables the tenant setting that lets data sent to Azure OpenAI be processed outside the capacity's geographic region. The capacity must also be in a supported region, and sovereign clouds are not supported. Sources: the Microsoft Learn pages "Copilot for Power BI overview" and "Copilot and Agent admin settings", read on 30 September 2026.
Can Copilot build the report straight from my Excel file?
Nearly. Loading the workbook in Power BI Desktop, or choosing New item > Semantic model > Excel in the Power BI service, creates the semantic model, and Copilot can then suggest or build report pages from it; Microsoft's own tutorial does this with a sample Excel file. The model also needs its Q&A feature switch on. So the file is not what stands in the way; the capacity is. Sources: the Microsoft Learn pages "Tutorial: Get Started Creating in the Power BI Service" and "Create and Edit Power BI Reports with Copilot", read on 30 September 2026.
Can Power BI make a report for me without Copilot?
Yes, a quick report. In the Power BI service you paste or type data into a table, and Power BI creates a semantic model and generates visuals for you from the fields you pick, each summed, averaged or counted as you choose. A CSV or Excel file has to be pasted, up to 512 KB, because a file upload option is not there yet, and pasted data cannot be updated later without creating the report again. A free Fabric licence lets you create one in your personal My Workspace. Once saved it becomes a normal Power BI report, and you can download the .pbix to keep working on it. Sources: the Microsoft Learn pages "Create Quick Reports in the Power BI Service" and "Interact with autogenerated 'quick' reports in the Power BI service", read on 30 September 2026.
Which of the four ways should I choose?
Build it yourself when you know Power BI and want every decision to be yours. Try a quick report when the data is small enough to paste and a few generated visuals are enough to start from. Hire a freelancer when the data needs cleaning first or the report needs someone to ask the right questions. Use a generator such as CompileBI when the data is already a table with a header row and you want a first version, with its measures written, to edit in minutes. They combine: a generated .pbip is an ordinary Power BI project that you or a freelancer can open and finish.
Does my data leave my organisation?
Yes. The workbook is uploaded to CompileBI and stored for its report, and building the report calls an AI model on OpenAI's API. The workbook itself never goes to an AI model. To plan the report, 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 masked shape of a few entries and your note. Columns we recognise as email, phone, ID, IP address or date of birth are left out, except for their names. The Privacy Policy lists it in full. If your organisation keeps data inside its region, as the data-boundary setting above does for Copilot, check with your admin before you upload: CompileBI is not a way around that setting.
What does CompileBI not do?
It does not clean your data: the workbook is read as it is. Every question the data could not support is listed with the reason, and a sheet it leaves out is named; neither is fixed for you. It needs Power BI Desktop to open the result, which is free and needs Windows 10 or later, as the Microsoft Learn page "Download Power BI Desktop", read on 30 September 2026, says. It has no language setting: the measure names and captions it writes are in English, and your column names are kept in their own language. Nothing is published to Fabric or to the Power BI service on your behalf: the result is a .pbip project file you download and open in Power BI Desktop.
What does it cost?
Free while we launch. Every account is on the Free plan today; the paid plans open soon at the prices shown. The Free plan builds one report a month with one change. Starter is 12 dollars a month for 10 builds, Pro 29 for 50. Prices are in USD before tax and can be changed or cancelled any time.