fbpx
[email protected] +1 203-349-9909 / +91-8080042523

How to Navigate Query Editor Using Power Query

While using Power Query, you might’ve come across a step that reads ‘Navigation’  in Applied Steps pane and it is automatically created by Power Query. But, do you know what it is used for?

Navigate Query Editor Using Power Query

The code generated by this step is = Source{[Item=”Sheet1″,Kind=”Sheet”]}[Data]

This is one of the ways that Power Query automatically creates a navigation step, but there are other ways to create this step and depending on the situation Power Query might create a different code.

There are three types of navigations in Power Query viz. Column Navigation, Row Navigation, and Cell Navigation.

Let us refer to the below steps to study all these navigation types.

Step 1: Drill Down Column

To navigate to a specific column, you should simply right-click on that column and select the ‘Drill Down’ option as shown below.

DRILL DOWN COLUMN

BECOME A BUSINESS INTELLIGENCE ANALYST COURSE
• Power BI • Excel to Alteryx • SQL Programming Language • SAS Programming • Tableau • KNIME • many more

 

Step 2: Drill Down Row

To navigate to a specific row, you should select that row simply right-clicks to select the ‘Drill Down’ option as shown below.

DRILL DOWN ROW

When you click on Drill down option, Power Query will only navigate for a specific column. To drill down the complete row, remove the column name from the formula in the formula bar and only keep = #”Changed Type”{0}

Step 3: Drill Down Cell

You can also right-click on any cell that you want to navigate and would get the ‘Drill Down’ option as well.

You can learn more :