Using data profiling tools
When creating Power BI reports, we can visualize key performance indicators (KPIs) and important charts to help us understand the data we work with. Once we are working with the data as fields from our report view, we need to go back into the Power Query Editor to make any changes to our data. To avoid going back and forth between these two views, you already want to understand some basic things about your data while you are still in the Power Query Editor in order to clean up your data accordingly. To already explore your data in the Power Query Editor, we can use data profiling tools. These easy-to-use tools will show us what our data looks like so that we can decide what transformations we still need to apply in the Power Query Editor.
The data profiling tools consist of three parts, as outlined here:
- Column quality
- Column distribution
- Column profile
You can find these three features in the View tab of the Power Query Editor...
