topic How do I see ALL queries in one code window? in Desktop

How do I see ALL queries in one code window?

Netrelemo — Tue, 02 Jun 2020 19:10:35 GMT

I have 25 data sources to work with, and each data source needs a whole heap of manipulation.

I can use the "advanced editor" to just write the code, instead of waiting for screen refreshes etc. But each data source has to be edited indivisually. Is there no way to just see ALL the code in one window. IF taht was possible, I should be able to do in 1 hour what currently takes me a whole day to do.

Re: How do I see ALL queries in one code window?

mwegener — Tue, 02 Jun 2020 20:38:52 GMT

Hi @Netrelemo ,

you can copy all queries into a text editor.

https://youtu.be/d-Ft_dvw-zI?t=209

Re: How do I see ALL queries in one code window?

Netrelemo — Tue, 02 Jun 2020 21:46:07 GMT

...and then I can separate the all out afterwards again.. 🤕🤕🤕🤕

Just when I thought I understood the extent of the admin overhead, it goes to a whole new level

Re: How do I see ALL queries in one code window?

v-lionel-msft — Wed, 03 Jun 2020 05:15:58 GMT

Hi @Netrelemo ,

It's impossible to achieve your idea in current version( 2.81.5831.821 64-bit (May 2020) ).

Unless you merge the tables of all data sources into one table.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: How do I see ALL queries in one code window?

mwegener — Wed, 03 Jun 2020 05:30:37 GMT

Hi @Netrelemo ,

maybe the tabular editor can help ...

https://github.com/otykier/TabularEditor/wiki/Importing-Tables#power-query-data-sources

Re: How do I see ALL queries in one code window?

Anonymous — Mon, 27 Feb 2023 16:56:20 GMT

It is possible! While in Desktop, go to File, then About, then you'll see an option to "Copy session diagnostics to clipboard". Paste that information into a text file, and you'll have access to all of your queries in one spot. It's not the 'perfect' solution, but with Find and Replace, you can update all your code at once, and then paste it back into the individual queries.