Hello there,

I have a problem importing some folders into power query. The interesting part is the different files in said folder seem to have a varying amount of columns – and power query only loads the columns that are in the example file.

I tried this twice, one set of data is a folder of PDFs. I choose the right page to extract and find out power query has only loaded the columns as in the example file – but i can load the others with some steps (picture):

The other set is a folder with CSVs. I try replicating the exact steps here, but Power Query does not load the additional column – if I refuse to choose an example file that has all columns already. If I want to automate said steps I can’t choose a fitting file every time, my only option is to accept Excel losing a column of data. Is there any way of preventing this? Thanks in advance.

​Hello there,  I have a problem importing some folders into power query. The interesting part is the different files in said folder seem to have a varying amount of columns – and power query only loads the columns that are in the example file.  I tried this twice, one set of data is a folder of PDFs. I choose the right page to extract and find out power query has only loaded the columns as in the example file – but i can load the others with some steps (picture):  The other set is a folder with CSVs. I try replicating the exact steps here, but Power Query does not load the additional column – if I refuse to choose an example file that has all columns already. If I want to automate said steps I can’t choose a fitting file every time, my only option is to accept Excel losing a column of data. Is there any way of preventing this? Thanks in advance.  Read More

​