From the course: Azure Data Factory

Unlock the full course today

Join today to access over 24,000 courses taught by industry experts.

Power Query

Power Query

- [Instructor] When you're trying to learn ADF, maybe you already have some experience using Microsoft Excel. And let me tell you about a former Microsoft Excel plugin, which is called Microsoft Power Query, which is nowadays a part of Microsoft Power BI. So if you have some experience on that particular technology, you can use it on ADF simply by querying and transforming your data based on Power Query. So let's create a new query based on Power Query. Let's give it a name and specify a dataset, maybe a new one, maybe one that is already existing. And then after a couple of seconds, Power Query is going to appear on your screen. Let's make some space here. Not everything is supported here, so it really depends on what you're doing. But let's do something simple here, like filtering on some data using Power Query. I will just filter on the documentary movies here on my data. So here I have the applied step, and if I want…

Contents