From the course: Power BI Data Methods (2019)
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Working with Query Editor steps
From the course: Power BI Data Methods (2019)
Working with Query Editor steps
- [Instructor] We record our extraction and transformation steps in Power BI using an array of function options. We see the types of functions available in the Power Query M guide available on the Microsoft website we see here, which can be a helpful reference. We can encounter two types of query editor errors. Row-level errors occur as individual hyperlink row errors in a data table. Examples include representing zeroes as dashes, which do not directly convert to numeric values. Step-level errors occur when the query editor step cannot return the intended result for the entire function performed or even the entire query. Examples include dividing a column of text values by a number. In the US Census Power BI file, we look at the GEOID to county web query. When we click on a step in the query over here in the applied steps, we see the function for that step in the formula bar at the top. The query editor applied…
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.