Today let’s go over some of the key features of the Power BI interface. We will go over how to connect to an excel file, and the important Power BI features we can use to transform the data.


2.The solution

After starting up Power BI you can connect to your data source. For this example, I have connected to an Excel file. Select the sheet, and click on transform data.

Now you have arrived in the Power Query Editor. There are a lot of options here, so let’s go over some of the important features.
 1. The home, transform, and add columns are used to convert data into structured tables.
 2. Queries contain the Power Query tables that are opened.
 3. The data preview area, which shows the first 1,000 rows of data.
 4. The formula bar, shows the “M” language formula.
 5. The properties which you can rename the sheet name.
 6. The Query steps, which list the steps that have been used to transform the data.

Zooming in, we can see the column names are in the first row of the data.

Click on home and select “use first row as headers”. Now the table will have the correct column names.

Now we have connected to the table we can start exploring other features of Power BI.

The Data School
Author: The Data School