updating table in power query

Category: sql server powerpivotexcel

Question

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. 

Replies

Nick Chobotar on Fri, 20 Jan 2017 19:38:14


Hello, 

I just did a quick test. It appears all additional columns from the source are getting pivoted in PQ upon refresh. 

N - 

Angelia Zhang on Mon, 23 Jan 2017 02:38:39


Hi Albo44,

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.

Best Regards,
Angelia