From the course: Power BI Data Methods

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Working with Power Query

Working with Power Query - Power BI Tutorial

From the course: Power BI Data Methods

Start my 1-month free trial Buy for my team

Working with Power Query

“

- [Instructor] In the last few years, we've seen a surge in data volume and speed, as well as an increased demand to understand and analyze trends from this data. Power BI allows us to scale up to this demand by creating models and reports that cater to business users and decision-makers. But before we get started with Power BI itself, let's talk about one of the most important functions built into Power BI, Power Query. Using Power Query enables us to connect to and transform data before we load it into our Power BI models. Power Query Editor formulas share similarities with their Excel counterparts, so you should already be familiar with many of these commands, but there are a few key differences that are important to know. First, Excel formulas are not case sensitive, while Power Query formulas are. Next, Excel counts from an index of one, while Power Query uses an index of zero. Excel type formula conversions are implicit, while Power Query ones observe strict data typing…

Contents