Albo44 on Fri, 20 Jan 2017 18:47:59
If I have a table in power query (that is unpivoted in the query, but pivoted in the actual table) and I add a bunch of columns will power query automatically update when I hit refresh? Grazie.
Nick Chobotar on Fri, 20 Jan 2017 19:38:14
I just did a quick test. It appears all additional columns from the source are getting pivoted in PQ upon refresh.
Angelia Zhang on Mon, 23 Jan 2017 02:38:39
It will refresh as Nick posted. You can test it using your data, you will understand it well. If you have any question, please feel free to ask. Thanks a lot.