New/changing columns in a Power Query source table

[cr731]

I have an Excel data table that I import into Power Query so I can perform various tasks such as unpivoting and merging of tables.

My source table, however, is frequently changing, such as adding/removing columns, and adding extra date columns (for instance, my table has a column for each month, and I regularly need to add new columns/months).

Power Query does not seem to handle this well. In particular, the first line after importing into Power Query, where Power Query goes through each column and guesses what type of data the column has, does not update for new columns.

Is there any way to make Power Query more dynamically reflect column changes or at the very least re-run that initial "import" step so it recognizes my most up to date columns?

 

[olivierhbh]

Hello,

I guess that you have a range of columns that doesn't change, then when unpivoting your date columns in PQ, instead of using "Unpivot columns" you should apprehend the problem the other way and select the columns you don't want to unpivot then apply the instruction "Unpivot other columns". That will "dynamize" the procedure.

 

[anvg]

Hi
Maybe it can help you to solve your problem Zippyshare.com - dynamicDemo.xlsx
Add or remove (but not all) month's columns.
Regards,

 

[ImkeF]

You can simply delete the auto-format-step. That way, all your new columns should be imported as well.