How to Create a Power BI Report from Excel
- George Apostolov
How to Create a Power BI Report from Excel: step-by-step guide
Open Power BI Desktop, click 'Black report'.
Make sure to select 'Import data from Excel' as your data source.
Browse and select your
.xlsxfile. Once done, click 'Open'.Power BI will show the list of tables/sheets in the file. Check the boxes for the ones you want to import.
Click 'Load' to load your dataset from Excel.
After loading, your Excel data is now part of your Power BI model.
Quick answer: To create a Power BI report from Excel, open Power BI Desktop and select 'Import data from Excel'. Next, browse and select your .xlsx file, choose the desired tables or sheets from the list, and click 'Load' to add your dataset into the Power BI model.
About this Excel tutorial
Import spreadsheets into Power BI Desktop by selecting your Excel file, choosing data sheets, and loading the dataset. This guide shows how to create a Power BI Report from Excel in 6 steps, starting with "Open Power BI Desktop, click 'Black report'" and finishing with "After loading, your Excel data is now part of your Power BI model". The interactive demo above is a click-through copy of the real Excel interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to create a Power BI Report from Excel?
6 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Excel data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Excel and Power BI. Related guides: How to create a report microsoft excel, How to Create a SharePoint List From Excel and How to create a workbook in ms excel. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
