fbpx

Category

Power BI

Top 5 Ways to Import Web Data in Power Query

The good thing with Power Query is that there are multiple ways to pull in data. Import Web Data Using Power Query One of the way is to get data from the internet by using the importing web data feature.  Let us see how we can parse a webpage and use it for Power Query....
Read More

Learn How to Filter Records Using Power Query

Filter records is a feature of Power Query that allows you to filter the data from your data table. Let’s see how to filter the records in Power Query with an example. Filter Records By Power Query Step 1: Load Data in Power Query Sometimes the data table is too huge and you do not want...
Read More

How to Unpivot Data Using Excel Power Query

Power Query allows you to extract data from any source, clean and transform the data and then load it to another sheet within the Power BI Designer canvas. The power Query is an advanced excel online function that enables you to connect, discover, refine and combine data sources to meet your data analysis needs. Unpivot...
Read More

Consolidate Multiple Excel Sheets Using Power Query

If you have multiple Excel worksheets that are in the same format and their underlying differences are their values and dates (e.g. January Sales List, February Sales List, March Sales-List, etc), then we can easily consolidate all the worksheets into one. The advanced excel function like Power Query will help you to consolidate multiple excel...
Read More

Consolidate Multiple Excel Workbooks in Power Query

The limitation of Excel of consolidating multiple Excel workbooks into one has overcome by Power Query.  Power Query can do this consolidation task in a couple of minutes. This is explained below within a few easy steps. Consolidate Multiple Excel Workbooks By Power Query Step 1: Open Excel Workbook from Folder Suppose you have an Excel...
Read More

Learn How to do Reverse Rows Using Power Query

Sometimes you need to show the data in a reverse form for some of the other reasons. It’s not easy to reverse rows without Power Query in Power BI. Power Query can do it in a fraction of second without losing any valuable information. Reverse Rows By Power Query Let’s take an example where you...
Read More

Read How to Group Rows And Get Counts Using Power Query

Power Query allows you to group rows and get the counts of each group very easily. Group Rows And Get Counts By Power Query Let’s go through the steps in detail. Step 1: Select the column in Power Query To group rows, we first need to select the column from which we want to group...
Read More

Learn How to Create Pivot Columns Using Power Query

To simplify your data and aggregate them together we can Pivot the huge data table using Power Query Editor in Power BI. This amazing feature of Power Query has hundreds of benefits. We can use it for a data source that has too many numbers of columns and rows. Create Pivot Columns Using Power Query...
Read More

Read How to Remove Duplicates Using Power Query

Power Query cannot only keep duplicate records but also can remove the duplicate data. The advantage of this feature is that it removes the human error whenever you try to delete your duplicate data manually. Remove Duplicates by Power Query Suppose you have this set of data. As you can see the marked ones are...
Read More

Acquire Knowledge to Fill Down Values Using Power Query

Power Query helps you to perform a series of steps to transform your data. Among which there is a step that allows you to fill data down easily. This feature is specially used to fill the missing data where predictions are available for the missing data. Power Query Helps To Fill Down Values Let’s suppose...
Read More

Steps to Remove Columns Using Power Query

Another feature of Power Query is Remove Columns. This feature allows you to remove the unwanted columns easily. Learn Steps to Remove Columns By Power Query This is helpful when you have columns that you want to eradicate and do not need in your final report – but do want to keep in your source...
Read More

Connect to Data in Power Query

Power Query is the Microsoft Data Connectivity and Data Preparation technology that allows the users to flawlessly access data stored in hundreds of data sources and reshape it to fit their needs. What is Power Query Editor in Power BI? Power Query can replace, merge, clean and transform all the messy data and display it in...
Read More
1 2 3 4