Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

0

Need a search function in Advanced Query Editor

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

Status: Delivered
Comments
v-qiuyu-msft
Community Support

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
Not applicable

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
Community Support

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

v-qiuyu-msft
Community Support
Status changed to: Delivered
 
Anonymous
Not applicable

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

andremichel
Regular Visitor

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.