Forum Discussion
Refreshing data sets
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.
Thanks for comming back to me, I did click on "Refresh Preview" but it wasnt updating or fetching the new columns, any other ideas?
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.
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