Hello All,

I am picking .CSV files from a folder through Power Query (Name: "Traslados_Envia_csv"). Recently the owner of the .CSV Files has added a new Column ("Column 9") with some new data. Once I tried to refresh the Query it shows the following error "[DataFormat.Error] There were more columns in the result than expected" (This error disappear if I delete this new Column manually. However these data has to be keep it)

When I go to the query I have tried to modify the Code in the "Advance editor" by trying to add the Column manually but the problem is not solved. See below:

Original Line

#"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"Column1", "Column2", "Column3", "Column4", "Column5", "Column6", "Column7", "Column8"}, {"Custom.Column1", "Custom.Column2", "Custom.Column3", "Custom.Column4", "Custom.Column5", "Custom.Column6", "Custom.Column7", "Custom.Column8"}),

Modification

#"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"Column1", "Column2", "Column3", "Column4", "Column5", "Column6", "Column7", "Column8", "Column9"}, {"Custom.Column1", "Custom.Column2", "Custom.Column3", "Custom.Column4", "Custom.Column5", "Custom.Column6", "Custom.Column7", "Custom.Column8", "Custom.Column9"}),

It seems that they way that I build the models does not work with dynamic columns ?

 

Please find Enclosed:

File where the query is done: "BOLSA_VS_GUIAS_ENVIA _V2" (The query is in the Tab "Traslados")

Raw File: "34969_ORIGINAL_$1.169.797" (The file with the new Column that causes the problem)

Raw File "32295_01032021_$1.139.200" (Sample file with the old layout, wich with the Query works)

 

Additional notes:

• The File has two additional Querys more. The A That pulls .xls file from the same folder where Query B (causing the problems) pulls the . CSV files and a C Query that joins Query A and B.  
• If you want to replicate the exercise please check that the query is looking for the location of the folder in the Tab "DyRefs" cell "K4"

 

I have done some research but I have not found a proper solution.

Thanks in advance.