Forum Discussion
Power Query Text editor
Hello everybody,
I have a data in which i merge about 40 different queries to get one evalutaion sheet of the data. For the documentation of the queries I would like to copy the M-Code of the queries and would like to save it in word file.
Is there a possibilty to read out the code for all queries in one, or do I have to open the extended editor for each query and copy it to the word file. This would be very "labor intensity"
Thanks in advance for your help.
Anonymous , I was under impression that your queries are located in single file like in the picture below and you wanted to get all of their content in some text editor.
You may select many queries like files in Explorer - just select first in the list, press Shift key and select the last one or press Ctrl select some of them. I am a bit lost. You don't need to open Advanced Editor to copy a text of your query/queries. Select and copy it's name (or several names) on the left pane of PQ editor. Then paste it in word processor and see what happens.
4 Replies
Hello, Anonymous select all query names/titles in editor, Ctrl-C and Ctrl-V in your word processing app.
Anonymous , I was under impression that your queries are located in single file like in the picture below and you wanted to get all of their content in some text editor.
You may select many queries like files in Explorer - just select first in the list, press Shift key and select the last one or press Ctrl select some of them. I am a bit lost. You don't need to open Advanced Editor to copy a text of your query/queries. Select and copy it's name (or several names) on the left pane of PQ editor. Then paste it in word processor and see what happens.