Refreshing data sets

[UK_User123456]

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 refresh the data set.

Is it a case of having to delete the old table in power query and then re-import the data set with the updated csv file, if this is the case, is it not an oversight from microsoft as surely I am not the only one who would need the data set to refresh if a column is either added or taken away in the raw data set?

Any help would be much appreciated.

TIA

[d_gosbell]

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.

[UK_User123456]

Thanks for comming back to me, I did click on "Refresh Preview" but it wasnt updating or fetching the new columns, any other ideas?

[d_gosbell · Accepted solution]

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.

[UK_User123456]

Hi, @d_gosbell, looks like that will need to be the answer for now. Helps alot rather than having to re-import the csv file each and everytime a new column is added or taken away.

Thanks