What is Power Query in excel: how to use Power Query in excel

What is Power Query in excel

Power Query in excel helps in connecting multiple sources and sizes of data. It helps in defining an automated process while connecting the first time and this can be used multiple times to save time and resources.

Excel Power Query is a business intelligence tool to perform extract, transform and load functions in Excel/Power BI. It has a graphical interface to load data and Power Query Editor helps in transforming data in a desirable way.

How to use power query in Excel

To use power query in excel we need to go in ribbon and select Data option. We will get first options as Get & Transform Data. In this option we get option Get Data which has more options to get data from multiple sources as shown in second image.

What is Power Query in excel
What is Power Query in excel

We can choose any option to get data from the given source.

What is a Power Query and how to use it?
power query

In this example, we can use csv to understand how Power Query works. Usually, CSV and text are most used options to load data in excel.

Power query
import data from csv

It will ask us to take to the folder from where we want data file to connect.

power query
importing data
power query
What is Power Query in excel: how to use Power Query in excel 11

By following the above steps we will get our data, which now needs to transform(using Transform Data) or can be directly load(Load option) into the excel file. We will try Transform Data option to understand it better.

BB7
What is Power Query in excel: how to use Power Query in excel 12

We will get options to transform our data. There are multiple tabs to transform the data. We can remove undesirable columns and can change columns data types.

After transforming we will load the data in excel. There are two options to load the data. The first option directly loads the data to excel and the second option gives us an option like below to load to a specific cell where data needs to load.

Power query data
power query

That’s all for this blog. I Will elaborate on Excel Power Query further in different blogs.

You can read more on power query excel from the below article.

https://www.howtoexcel.org/power-query/the-complete-guide-to-power-query/

1 thought on “What is Power Query in excel: how to use Power Query in excel”

  1. Pingback: How to transpose excel rows to columns:3 Ways to Transpose Data in Excel - Learning, we made it Easy

Leave a Comment

Your email address will not be published. Required fields are marked *