Power Query is importing 16,000 columns and its slowing my process...

[Guitarmageddon]

Hey folks, hopefully this is a quick fix. I have a little survey tool that only has several columns on the input file. For some reason, when bringing into power query, its bringing in all columns known to man. I have some snips from the advanced editor below...

In the expand columns step here, you can see it starts to identify EVERYTHING....

And here is where it finally finishes...after identifying over 16,000 columns. Without directly modifying the source template that I have the users dumping into the directory, is there a way to increase the query speed by not letting it identify all these columns? Im assuming its what is causing importing these several dozen files to take ridiculously slow. I only need to bring in up to column 6. the rest is junk, as you can see from the "remove other columns" step.

 

[RoryA]

Put a list of the column names you want into the Table.ExpandTableColumn step instead of the Table.ColumnNames function. Then delete that changed type step and redo it with just the columns you want.

 

[Guitarmageddon]

Put a list of the column names you want into the Table.ExpandTableColumn step instead of the Table.ColumnNames function. Then delete that changed type step and redo it with just the columns you want.

Yep this did the trick! Thanks for pointing that out.