Data Cleansing

In this exercise, you will create a Dataflow that loads two data files, and use the Power Query interface to inspect the files for invalid records requiring data cleansing.

Table	Issues
ds-categories-RAW.csv	Contains some rows that do not fit the column/row pattern of a regular CSV file
ds-orders-RAW.csv	Contains some rows with empty or invalid values for some columns

Note: If you get an error about an API rate limit, this usually happens because a previous Fabric task has not completed. You can view active Fabric tasks from the Monitor page (located on the left horizontal menu). Canceling old Fabric tasks in the Monitor page will usually resolve the rate limit error.