Master Get & Transform data in Power BI through Query Editor

This Video explains steps to import data into Power BI from Excel file - using Sheets, Tables or named range in Excel file.

This video explains steps regarding importing text files into Power BI.

This video explains steps for importing data from CSV delimited files into Power BI

This video explains steps for importing tables and query data from MS Access files into Power BI.

This video explains how you can deactivate loading of data into Power BI Data Model, How you can change file path in Query Editor.

Power BI Query editor contains various transformation. In this video i show you in built column transformation options either from query ribbon or mouse right clicks. These are starting blocks to learn about power query.

Power BI Query editor contains various transformation. This video explains various row transformation inbuilt in Power Query Ribbon. How to keep or remove rows - Top Rows, Bottom Rows, Range of Rows, Duplicate Rows, Blank Rows, Error Rows. It also explains Group By feature available in Power Query.

In this video I will show how filtering columns in Power BI Query Editor is case sensitive and how it is different compared other tools filtering.

Power BI Query editor contains various transformation. This video will explain you about the Text transformation available with Power BI Query Editor ribbon itself.

Power BI Query editor contains various transformation. This video will explain you about the Number transformation available with Power BI Query Editor ribbon itself.

Power BI Query editor contains various transformation. This video will explain you about the Date transformation available with Power BI Query Editor ribbon itself.

When you are performing Data cleansing it always happens that you need to have different result based on condition met. In this video I will show how you can create condition column results inside Power BI Query Editor.

This is introductory lecture about topics covered in this Power BI Query Editor mastery course section.

When you have multiple data source you may want to append them. Doing it manually may take lot of time. In this video I will show you how you can automate this using Power BI Query Editor and append multiple datasets quickly.

When you have stored multiple files in a folder and would like to import ALL the files, you can do that using Power Bi Query Editor very quickly. To learn more watch this video.

In previous video our focus was on multiple files, however if you would like to import data from multiple excel sheets in one query itself then this video will explain you. This video will show you steps in Power BI Query Editor.

Once you have data imported in and have perform various transformation steps on it you may like to perform same steps on data for different period or region. In this video I will show how you can duplicate or reference query in Power BI Query editor. I will also explain you the difference Duplicate query and referencing a query.

This video explain basic concepts related to different types of Joins in Power BI Query Editor

This video explain basic concepts related to different types of Joins in Power BI Query Editor.

This video is second part for Left and Right joins available in Power BI Query Editor.

In real world there are datasets which require a little different type of joins which are not currently inbuilt in Power BI Query editor. In this video I will show you how you can perform cross joins in Power BI Query editor.

This video explains brief details of M Language in Power BI Query Editor.

Power BI Query Editor has various transformation available in ribbon interface, however there are much more transformation which can be manually entered. In this video I will show various Text related M functions available in Power BI Query Editor.

Power BI Query Editor has various transformation available in ribbon interface, however there are much more transformation which can be manually entered. In this video I will show various Date related M functions available in Power BI Query Editor.

Power BI Query Editor has various transformation available in ribbon interface, however there are much more transformation which can be manually entered. In this video I will show various Logical M functions available in Power BI Query Editor.

This is new feature introduced in Power BI Query editor through which it can sense what you want perform on dataset e.g. split, merge, convert, etc. In this video I will explain you how to use Column from examples feature with real data.

There is sample financial dataset spread across multiple years. This needs to be converted into columnar format. I will show all the steps through which you can convert it using Power BI Query Editor.

In this video we will be using sample dataset for certain employees spread across various month in year. However with the current format we are not able to perform any analytics and hence we need to convert it into columnar format. I will show all the steps to convert it using Power BI Query editor.

When you copy data from website which does not allow you to access tables easily, this data gets stacked up one above another for multiple pages. In this video we will look at similar datasets for customer contact details which stacked up. How can we convert it into appropriate format is shown in this video using Power BI Query editor.

Many time it happens that you have to select multiple items as filter for a single column. It can be time consuming if you have to perform repeatedly and also filters keep changing. In this video I will show how you can use Merge queries option in Power BI Query Editor to resolve this.

In this video we have a dataset where data is stored in alternate rows across various columns. We would need to convert this kind of data to columnar format. I will show you all the steps using Power BI Query Editor in this video.

There are multiple discount rates based on region and sales amount. Instead of manually looking up we can use Power BI Query editor merge queries features to get appropriate discount rate. I will show you that in this video.

A single invoice can contain multiple items. In this video a dataset is extracted from system which contain single row for each invoice and multiple columns for items included in that invoice. We need to convert this data so that we can perform some data analytics. I will show all the steps using Power BI Query Editor for this.

Power Bi Query Editor contains List, Records, Tables, Binary Values, etc. as object. Also there are some peculiar things about these objects which we will learn in this section.

I will show how you can use List as part of your Power BI Query, what syntax you need to use it.

I will show how you can use Records as part of your Power BI Query, what syntax you need to use it.

I will show how you can use Table as part of your Power BI Query, what syntax you need to use it.

This video recap details about various Power Query Objects.

In this section we will look at little more complex datasets for perform transformation using Power BI Query Editor.

If you want extract only certain line items from text, csv files which contains other data then you can follow the steps shown in this video using Power BI Query Editor.

How you can create a dynamic calendar table which will automatically populate multiple columns like month, day name, etc. based on value you input. We will look at all the steps involved in Power BI Query editor to get this calendar.