Loading and Combining data from folder not loading all columns - missing last column

[hananak]

Dear All,

I need your help in regards to the problem I am facing in Power Query in Excel.

I have a folder where every month I save monthly Transactions Report. Then I combine them using Power Query to get YTD Report. All the columns names are same and it was all going well. Today I saved the latest month report. Now the PQ says it cannot find one column name. I have compared the columns and their names and sequence, everything is matching. There is no change to the report.

In my monthly files, there are 38 columns. When I checked PQ and now it is loading/showing only 37 columns in PQ editor. It is not loading/showing the 38th column. I have no clue what has gone wrong.

Any help would be really appreciated.

Thanks.

 

[hananak]

Dear All,

I need your help in regards to the problem I am facing in Power Query in Excel.

I have a folder where every month I save monthly Transactions Report. Then I combine them using Power Query to get YTD Report. All the columns names are same and it was all going well. Today I saved the latest month report. Now the PQ says it cannot find one column name. I have compared the columns and their names and sequence, everything is matching. There is no change to the report.

In my monthly files, there are 38 columns. When I checked PQ and now it is loading/showing only 37 columns in PQ editor. It is not loading/showing the 38th column. I have no clue what has gone wrong.

Any help would be really appreciated.

Thanks.

Also just to add, I have tried to load all the files from a folder in a fresh query in a new blank file. PQ is still not loading all the columns. Currently only loading 37 columns out of 38.