Forum Discussion

UK_User123456's avatar
UK_User123456
Resolver I
7 years ago
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...
Need Help
  • d_gosbell's avatar
    d_gosbell
    7 years ago

    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's avatar
UK_User123456
Resolver I
7 years ago

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's avatar
d_gosbell
Super User
7 years ago

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's avatar
    UK_User123456
    Resolver I
    7 years ago

    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