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

Add Search and Replace Functionality to the Power Query Advanced Editor

People end up constantly copying the code to Notepad to search for and replace text.
Status: Needs Votes
Comments
r_lemmens1
New Member
The Advanced Editor is very limited, I find myself copying the code to something like Notepad++, use find and replace and copy the code back.
Conor_Savage
New Member

The ability to use CTRL + F to find words in Advanced Editor of Power Query to improve ease of editing complex queries.

Anonymous
Not applicable

Absolutely needed this the other day. I was coming back to a report which gets updated yearly. I needed to search through some hairy functions for a particular reference that may or may nit have been there. This would have helped out a lot.

Viktor_Wolf
New Member

When opening the advanced editor in power query window, it is often necessary to copy the whole text into an editor like Notepad++ or Visual Studio only to search for specific word or pattern. Please provide search function to the Advanced editor.

Thanks.

greg_galloway
New Member

Agreed! Better yet I wish there were a search button in the Power Query ribbon to search every Power Query. Search and replace to replace all mentions of a column in all queries or replace all mentions of a database name with a parameter would be awesome.

j_serna
New Member

Add a "find and replace" functionality to the Power Query Advanced editor. These way it is easier to find columns you have used in the past or find a specific part of your code.

fbcideas_migusr
New Member
Status changed to: Needs Votes
 
fbcideas_migusr
New Member
Status changed to: New
 
fbcideas_migusr
New Member
Status changed to: New
 
fbcideas_migusr
New Member
Status changed to: Needs Votes