To transform the People query, performing the following steps:
- Click on the People query in the Queries pane. Notice that four steps have already been created in this query, that is, Source, Navigation, Promoted Headers, and Changed Type. Power BI has automatically added a number of query steps to make the first row the column names and identify the data types of the columns. The first four columns, that is, ID, Name, Title, and Employee Type, have all been identified as text (ABC). The next two columns, TermDate and HireDate, have a calendar icon. These are date columns. The final column, Location, is a text column (ABC).
- Ensure that all of these columns have the correct data type. If not, change their data type by either clicking on the data type icon in the column header or choosing the Transform tab of the ribbon and using the Data Type dropdown in the Any Column section. When you are finished, your data types should be the same as the ones in the following screenshot:
Figure 11: Column data types for the People query