Here’s how to record data in Power BI:
- Let's start by opening Power BI Desktop and clicking on 'Blank report' to begin recording data.
- Choose 'Import data from Excel' as your data source for recording the information you need.
- Navigate to your .xlsx file location, select it, and click 'Open' to access the data.
- Power BI will display all tables/sheets in your file. Simply check the boxes next to the ones you want to record in your report.
- Click 'Load' to bring your selected data into Power BI.
- Your Excel data is now recorded in your Power BI model and ready for you to create visualizations with it.