importing data into PowerBI

This is the best way to start with a blank canvas:

First, open the Home ribbon and click on Get Data. A window will pop up; the right side lists all available data sources, and the left side allows you to filter them by classification. After identifying the data source you need, click the Connect button.

Second, select Excel as the type, and an 'Open File' dialog box will appear. After locating the file and clicking Open, you need to select the worksheets you want to import and then click the Load button.

Finally, all the data has been loaded. You can now browse the table names and fields.

Now, you can create visuals and reports, and perform further analysis.