Adolfo_Socorro's avatar
Adolfo_Socorro
New Member
5 years ago
Status:
Needs Votes

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.
Data Factory | Dataflow
power bi

13 Comments

  • r_lemmens1's avatar
    r_lemmens1
    New Member
    6 years ago
    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.
  • Viktor_Wolf's avatar
    Viktor_Wolf
    New Member
    3 years ago

    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's avatar
      greg_galloway
      New Member
      2 years ago

      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.

  • Conor_Savage's avatar
    Conor_Savage
    New Member
    3 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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.

  • j_serna's avatar
    j_serna
    New Member
    1 year ago

    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.

  • SMYTH's avatar
    SMYTH
    New Member
    1 year ago

    Please add a Find and Replace feature in the Advanced Editor within Power Query.

    This feature is badly needed for users working with large, complex M code scripts. When editing long queries with many steps, it's currently impossible to search for variable names, column names, or specific expressions within the editor itself. There is also no way to do a basic "Replace All" operation, which forces users to copy the code into an external editor like Notepad++ or VS Code, then paste it back in.

    Adding even a basic Ctrl+F / Ctrl+H interface (like in DAX editor or Visual Studio Code) would greatly improve productivity and reduce human error during manual code edits.

Recent ideas