Forum Discussion
Solved
Refreshing data sets
Hi All, I have just come across this, I have had to add in an extra column into my csv data set, but when I go to refresh my data in power query, it doesnt seem to add in the new column, but will...
OK I think I see what's going on here. If you click on the "Source" step in your query you will notice that when you first created your query that it hard coded the number of columns. Manually increasing this number by the number of columns that you added is one way of working around this issue in the short term
I'm not sure why the refresh preview button does not do this itself as I think it should.
Power Query caches a preview of your query to make it faster to work with, but sometimes if you change the underlying source data it's not immediately visible. The way to fix this is to click on the "Refresh Preview" button in the Home ribbon while in the Query Editor.