Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

Fix 'Go To Columns' feature in Power Query in Fabric

In Power Query in Excel, the 'Go to Columns' feature does something incredible - it switches you to the column that you choose.

In Fabric, not so much.

 

Please get this feature to work in Fabric like it does in Excel.

This small fix will save user time.

Status: Need Clarification

Could you share some repro steps of the issue? I've just given it a try and it appears to work as designed.

 

For example, for the query below:

let
  Source = OData.Feed("https://services.odata.org/V4/Northwind/Northwind.svc/", null, [Implementation = "2.0"]),
  #"Navigation 1" = Source{[Name = "Customers", Signature = "table"]}[Data]
in
  #"Navigation 1"

I am able to see that it has many columns and the data preview doesn't allow me to see all of them.

miguel_0-1772717020718.png

 

I can then use the "Go To column", select a column that I'm unable to see like "Fax":

miguel_1-1772717076113.png

 

And it takes me to the Fax column:

miguel_2-1772717105259.png

 

 

Comments
miguel
Community Admin
Status changed to: Need Clarification

Could you share some repro steps of the issue? I've just given it a try and it appears to work as designed.

 

For example, for the query below:

let
  Source = OData.Feed("https://services.odata.org/V4/Northwind/Northwind.svc/", null, [Implementation = "2.0"]),
  #"Navigation 1" = Source{[Name = "Customers", Signature = "table"]}[Data]
in
  #"Navigation 1"

I am able to see that it has many columns and the data preview doesn't allow me to see all of them.

miguel_0-1772717020718.png

 

I can then use the "Go To column", select a column that I'm unable to see like "Fax":

miguel_1-1772717076113.png

 

And it takes me to the Fax column:

miguel_2-1772717105259.png