mass update if add new column in the table that import from folder

Joey-G Indeed. When you add a column outside Power Query the information in that column is no longer synchronized when you refresh the query and when new files were added. Google for "self referencing query power query" and you'll find many resources describing how to deal with the issue. Pick one that suits you best. You could use the file name as a unique identifier to merge the query with its previous output that has the column added to it manually.