Need a search function in Advanced Query Editor

[Anonymous]

I often use the Advanced Query Editor but if I am dealing with a large query and I know a keyword for the section I am looking for, I would like to be able to do a ctrl-f and search for it.  Currently this is not possible, so I have to select all text, copy it, paste it into a text editor, find the keyword, edit it, then copy and paste it back into PowerBI. 

I would think this should be pretty easy to add into PowerBI to stop the extra work of copying and pasting.

Thanks

[v-qiuyu-msft]

Hi @Anonymous, 

It's easy to discover function names, function parameters, column names and many other UI enhancements (line numbers, syntax coloring, etc.) both in Formula bar and Advanced Editor via M Intellisense. For more information, see: 

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-april-2019-feature-summary/#intellisense

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-june-2019-feature-summary/#intellisense

Best Regards,
Qiuyun Yu

[Anonymous]

Thanks @v-qiuyu-msft , but intellisense doesn't really solve the problem of being able to quickly search for a keyword to jump to that position in the advanced query editor.   If this feature exists in (say) Visual Studio Code because developers need to be able to do this, then why wouldn't people using Power BI's advanced editor not need this?

[v-qiuyu-msft]

Hi @Anonymous, 

I'm afraid this kind of search feature isn't available in Advanced Editor currently. Please vote on this same idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/37603210-enable-search-box-within-the-advanced-editor

Best Regards,
Qiuyun Yu

[Anonymous]

OK, thank you @v-qiuyu-msft  - I've voted there.

[andremichel]

Intellisense highlights every instance of a word in the "Power" Query Advanced Editor. Therefore, if you knew the word/error you were looking for, all you would have to do is type it in the open area of the Advanced Editor and it would be made visible.

For instance if I was searching for the keyword "Power", I could simply type power again, click into any character in the text and all instances of "Power" would appear highlighted with the same color.