From the course: Power BI Data Methods
Unlock the full course today
Join today to access over 23,200 courses taught by industry experts.
Managing errors - Power BI Tutorial
From the course: Power BI Data Methods
Managing errors
- [Instructor] When we build queries to load into Power BI, there are two types of errors that we'll run into. Step level errors occur when the query editor's step cannot return the intended result for the entire function performed, or even the entire query. Row level errors occur for individual values in a row within a field. We'll see these errors as error hyperlinks in our query. Both types of errors are problematic, but I find the row level errors are more common and harder to catch. Let's explore these errors in our Power BI model. To create a step level error, let's intentionally move the changed type step in front of the function to add a custom column. This throws an error message for entire query. To fix this issue, let's move the changed type step to its original position at the end. Next, in our data table, let's change our date field to a date and our amount field to a decimal number. Notice error hyperlinks appear in the data table for the rows where the value in that…
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.