From the course: Power BI Data Methods (2019)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Fixing errors
- [Instructor] Most of the errors that I ran into when loading data into Power BI come from incorrect data types. Fixing errors after loading can be a huge pain and slightly cumbersome, but recent Power BI update, and a bit of insight on your end, can make this process much smoother. In the manual sample Power BI file, let's set the sample data table so it loads with errors so we can work through how to fix them. Earlier, in the applied steps, we replaced the dash values with zeros. Let's click on the X next to the step name, so that the Change Type step now gives us errors. One of the newer developments in Power BI is the colors below the column name, where we see a red line indicating errors in the data set. Our sample data set is small so we can see the errors, but the likelihood you will not be able to see these row level errors gets much higher when you're working with a much larger data set. Load this data by…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.