This lesson's interactive features are locked, please to keep using them

Changing Data Types

From the Data/Table view, you can manually change the data type of a column if Power BI misinterpreted it during the import process. This happens all the time with things like dates and numbers. You always want the most accurate data type for each column!

To change a type, use the dropdown menu as shown below:

Assignment

Import the website_sessions.csv file into Power BI (Home → Get Data → Text/CSV).
Go to the Data/Table view (the chart-lookin' icon on the left under Report view).
In the Data pane on the right, notice that you can now switch between customers and website_sessions. Click on website_sessions to select that table.
Power BI should have properly detected that the session_purchase_made column contains Boolean (True/False) values, but for practice, change it to a Text column for now.

Save the project and, from the course directory, submit the CLI tests.

If you see tests failing because no metadata file has been generated for the new website_sessions table, you may need to do the trick where you go into the Model view, move the table slightly on the canvas, and save the project again. It's unclear why this problem occurs for some users.