Hi
I'm was sure that this was in the Power Query course but I've just watched all the videos under "data destinations and refreshing queries" and couldn't find it.
There was a way to load a table into Excel from PQ that wasn't the normal Close and Load, and it allows you to add additional columns such as formulas, which don't disappear if you refresh the query.
Did I imagine this?
Thanks!
Mardi
Hi Mardi,
Yes, in theory you can add columns in Excel beside the Power Query table and when PQ refreshes it won't remove the data, but it's a bit risky because if the order of the data returned by PQ is different to the original data, the rows you've added will also be out of alignment.
It's better to add the column from within PQ, or add it in a separate table and then merge the tables in PQ to get a final table.
Mynda