Forum Discussion
Add Text edit capacities to the Advance Editor
Currently, Power BI's Advanced Editor in Power Query does not support rich text editing features such as Find & Replace, syntax highlighting, or the ability to leave comments or visual formatting like highlighting or emojis. It is a simple code editor for editing M language and lacks the advanced editing capabilities commonly found in modern code editors.
Suggestions and Workarounds
Many community users echo your feedback and would like features like global Find & Replace, multi-select editing, highlighting, commenting, and richer formatting support.
Currently, the best option is to copy your M code to a dedicated code editor such as VS Code (which supports these features), make your edits, and paste the code back into Power BI.
Feature requests for a more advanced editor with text manipulation and formatting options are already popular in the Power BI community.
for now, use an external code editor for heavy text editing and continue upvoting or providing feedback so Microsoft can consider adding these capabilities to the Advanced Editor in Power Power BI.