Import & export queries in 2010 & 2013?

[Charley]

Is there a way to import and export queries in 2010 and 2013, as we can in 2016 with ODC files?

The only way I've found is to copy and paste M code.

What am I missing?

 

[Ron Coderre]

Hi, Charley

Have you tried this:
Source workbook....
- Display the PQ Query Pane
- Hold CTRL while you select the queries you want in another workbook
- Right-Click on one of the selected queries...Select: Copy

Destination workbook
- Display the PQ Query Pane
- Right-Click in the Query Pane...Select: Paste

Is that something you can work with?

 

[Charley]

Ron,

Long time no talk with!

That's a slightly better way to do the same thing. The bottom line, I guess, is that it's safe to say that PQ 2010-2013 can't save ODC files.

Thanks.

Charley