Filling empty rows

Data sources can have their own specific structure on how data is shown. This may end up with having null values displayed on the table once this is imported into Power Query. In the following section, we will see an example that shows how you can fill missing data by keeping the original data source logic.

Getting ready

In this recipe, you need to download the following file in a local folder:

• FactInternetSales2 CSV file

In this example, we will refer to the C:\Data folder.

How to do it

Once you open your Power BI Desktop application, you are ready to perform the following steps:

1. Click on Get Data and select the Text/CSV connector.
2. Browse to your local folder where you downloaded the FactInternetSales2 CSV file and open it. A window with a preview of the data will pop up; click on Transform Data.
3. You can see how at OrderDate column level, there are some missing values:

   Figure 4.37 – Missing values

4. Select the...