Data profiling with Power BI Desktop

To access the data profiling capabilities in Power BI Desktop, we need to open the Power Query Editor. The easiest way to do this is by clicking on the Edit Queries button in the External data section of the Home ribbon, as shown in Figure 12-6:

Figure 12-6: Editing queries

This opens the Power Query Editor, where we can work on the data loading process for our data model. Figure 12-7 shows the Power Query Editor screen:

Figure 12-7: The Power Query editor screen in Power BI Desktop

On the left-hand side ...

Get Hands-On Business Intelligence with DAX now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.