New/changing columns in a Power Query source table

cr731

Well-known Member
Joined
Sep 17, 2010
Messages
611
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?
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
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.
 
Upvote 0
You can simply delete the auto-format-step. That way, all your new columns should be imported as well.
 
Upvote 0

Forum statistics

Threads
1,226,730
Messages
6,192,708
Members
453,748
Latest member
akhtarf3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top