cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Can't edit "Remove Other Columns" step in Power Query Editor

Hello,

 

I'm trying to add a column from a table that was originally not included to the dashboard.  I've always been able to double-click "Removed Other Columns" in the Applied Steps section in Power Query Editor.  However, nothing happens when I do that for this one particular table.  I also noticed that the applied steps usually have gear icons beside them, but this table has "i".

 

Please help me in adding back a column!

 

Capture.JPG

6 REPLIES 6
Highlighted
Super User VII
Super User VII

Re: Can't edit "Remove Other Columns" step in Power Query Editor

@dtango9  (i) Icon represents there are comments in the steps, it is weird that gear icon are gone, you can click advanced editor and add the column in the step or paste the code here from the advanced editor and can recommend you the changes.

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Helper I
Helper I

Re: Can't edit "Remove Other Columns" step in Power Query Editor

Thank you @parry2k 

 

From the appointments table, I would like to have the following columns included:

 

  • _regardingobjectid_value
  • scheduledend
  • description
  • statecode
  • subject
  • ownerid_value
  • statuscode
  • _newvvractivities
  • _newtradeinactivities

This is what is currently displayed in Advanced Editor:

Capture.JPG

Highlighted
Super User VII
Super User VII

Re: Can't edit "Remove Other Columns" step in Power Query Editor

@dtango9 weird, your script looks bad, you should have pasted the code rather image, 

 

anyhow, remove // from the line and add to others on as shown below, if you don't know, then paste the code rather than image

 

 

image.png






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Helper I
Helper I

Re: Can't edit "Remove Other Columns" step in Power Query Editor

Here is the pasted code, do you mind fixing?

let
Source = OData.Feed("https://carproof.api.crm.dynamics.com/api/data/v9.1/appointments?$select=_regardingobjectid_value,sc... eq 1) and (scheduledend ge 2019-11-01)", null, [Implementation="2.0"]),
//appointments_table = Source{[Name="appointments",Signature="table"]}[Data],
appointments_table = Source,
//#"Removed Other Columns" = Table.SelectColumns(appointments_table,{"_regardingobjectid_value", "scheduledend", "description", "statecode", "subject", "_ownerid_value", "statuscode"}),
#"Removed Other Columns" = appointments_table,
//#"Filtered Rows" = Table.SelectRows(#"Removed Other Columns", each ([statecode] = 1)),
#"Filtered Rows" = #"Removed Other Columns",
//#"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each [scheduledend] >= #datetimezone(2019, 11, 1, 0, 0, 0, -5, 0)),
#"Filtered Rows1" = #"Filtered Rows",
#"Changed Type" = Table.TransformColumnTypes(#"Filtered Rows1",{{"scheduledend", type date}})
in
#"Changed Type"

Highlighted
Super User VII
Super User VII

Re: Can't edit "Remove Other Columns" step in Power Query Editor

@dtango9 paste following code 

 

let
Source = OData.Feed("https://carproof.api.crm.dynamics.com/api/data/v9.1/appointments?$select=_regardingobjectid_value,sc... eq 1) and (scheduledend ge 2019-11-01)", null, [Implementation="2.0"]),
//appointments_table = Source{[Name="appointments",Signature="table"]}[Data],
appointments_table = Source,
#"Removed Other Columns" = Table.SelectColumns(appointments_table,{"_regardingobjectid_value", "scheduledend", "description", "statecode", "subject", "_ownerid_value", "statuscode"}),
//#"Removed Other Columns" = appointments_table,
#"Filtered Rows" = Table.SelectRows(#"Removed Other Columns", each ([statecode] = 1)),
//#"Filtered Rows" = #"Removed Other Columns",
#"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each [scheduledend] >= #datetimezone(2019, 11, 1, 0, 0, 0, -5, 0)),
//#"Filtered Rows1" = #"Filtered Rows",
#"Changed Type" = Table.TransformColumnTypes(#"Filtered Rows1",{{"scheduledend", type date}})
in
#"Changed Type"

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Post Partisan
Post Partisan

Re: Can't edit "Remove Other Columns" step in Power Query Editor

Using the Query Editor ribbon:

Select the column (or columns with Ctrl+Click or Shift+Click) you want to remove.

In the Query Editor ribbon, select Remove Columns > Remove Columns, or the inverse, which is Remove Other Columns to remove all columns except the selected column.

Remove columns using Query Editor

Using the Query Editor context menu

Select the column (or columns with Ctrl+Click or Shift+Click) you want to remove.

Right-click any selected columns.

From the context menu, select Remove to remove the selected columns, or Remove Other Columns to remove all columns except the selected column.

Query Editor context menu

Note: The Query Editor only appears when you load, edit, or create a new query using Power Query. The following video shows the Query Editor window appearing after editing a query from an Excel workbook. To view the Query Editor without loading or editing an existing workbook query, from the Get External Data section in the Power Query ribbon tab, select From Other Sources > Blank Query. The following video shows one way to display the Query Editor.

 

Admin

clouddesktoponline

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors