Column Count on Data Import

[HarryMay69]

Hi All

I am using a MRP system that exports various businees report daily as CSV files.

I have many Power Queries linked to the .CSV files in both Excel and BI.

The raw reports can be amended by the IT deparment for other users and aditional columns are added to the report.

Is there any way of setting up power query to ignore any new columns added to the original data import file.

At present all of my queries fall over in the applied steps when it trys to change type, for some reason it notices the new colum in the source data, and trys to promote headers, but in te change type field it cant recognise the header.

[HotChilli]

The 'remove other columns' will have to be before the Changed Type.

[HarryMay69 · Accepted solution]

Okay thanks, so I assumed as it auto fills in the first three applied steps thats the order they needed to be in.

[HotChilli]

How about inserting a step to 'remove other columns'?  If you select all the columns required with ctrl mouse click or shift mouse click then right-click, the option will be there.

This translates to a Table.SelectColumns call.

[HarryMay69]

Hi Yes I already have that but after the change type, i.e. after the auto populated three steps.

The source step is finding the new columns added in the data, then the promote headers is working but the change type falls over as it cant find the new columns promoted headers name. you just get this at the end of the code, , {"", type text}}) and you have to manually type in the new colum name.