Add Search and Replace Functionality to the Power Query Advanced Editor
13 Comments
- r_lemmens1New MemberThe Advanced Editor is very limited, I find myself copying the code to something like Notepad++, use find and replace and copy the code back.
- fbcideas_migusrNew MemberStatus added:Needs Votes
- Viktor_WolfNew 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_gallowayNew 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.
- fbcideas_migusrNew MemberStatus added:New
- Conor_SavageNew Member
The ability to use CTRL + F to find words in Advanced Editor of Power Query to improve ease of editing complex queries.
- AnonymousNot 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.
- fbcideas_migusrNew MemberStatus added:New
- j_sernaNew 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_migusrNew MemberStatus added:New
- fbcideas_migusrNew MemberStatus added:Needs Votes
- SMYTHNew Member
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.
- miguel
Community Admin
Status changed:Needs VotestoNeeds Votes
Recent ideas
Add Branch Compare Merge and Approval Workflows to Fabric Planning Scenarios
Fabric Planning supports scenarios, simulations, writeback, and collaborative planning. Enterprise planning teams also need a controlled process for developing multiple versions of a plan and promoti...mourakshit5 hours agoNew MemberNew4Views0likes0CommentsAdd Continuous Incremental Synchronization for Fabric ClickHouse Accelerated OneLake Tables
Fabric ClickHouse provides accelerated access to OneLake data for high-performance analytical workloads. For operational analytics and AI applications, a point-in-time accelerated copy can quickly be...mourakshit5 hours agoNew MemberNew4Views0likes0CommentsAdd Execution Preflight and Cost Guardrails to Fabric Data Engineering Agent
Fabric Data Engineering Agent can autonomously plan, execute, validate, and refine complex data engineering tasks. Before a long-running autonomous task starts executing against enterprise data, user...mourakshit5 hours agoNew MemberNew3Views0likes0CommentsAdd Automatic Query Plan Regression Detection to Fabric Data Warehouse
Fabric Data Warehouse is adding richer graphical query plans and AI-assisted performance diagnostics. A common production problem is identifying when a previously healthy query becomes expensive afte...mourakshit5 hours agoNew MemberNew3Views0likes0CommentsAdd Semantic Regression Test Suites to Fabric IQ Ontology Versioning
Fabric IQ is adding Ontology Versioning, CI/CD support, Ontology Metrics, Management APIs, and Ontology Agent capabilities. As ontologies become production assets, teams also need a way to verify tha...mourakshit5 hours agoNew MemberNew6Views0likes0Comments