Problems with updating DATA from folder - HELP!!!!

Hey Greg_Deckler , thnks for the fast response, this are the steps:

= Folder.Files("C:\Users\xxxx\folder")
= Table.SelectRows(Source, each [Attributes]?[Hidden]? <> true)
= Table.AddColumn(#"Filtered Hidden Files1", "Transform File", each #"Transform File"([Content]))
= Table.RenameColumns(#"Invoke custom function1", {"Name", "Source.Name"})
= Table.SelectColumns(#"Columns with name changed1", {"Source.Name", "Transform File"})
= Table.ExpandTableColumn(#"Other Columns Removed1", "Transform File", Table.ColumnNames(#"Transform File"(#"Example File")))
= Table.TransformColumnTypes(#"Expanded table column1",{{"Source.Name", type text}, {"GROUP", type text}, {"TIME", Int64.Type}, {"ARL", Int64 .Type}, {"OPE_STATUS", type text}, {"PI_SOTR", Int64.Type}, {"ARL_ECON", Int64.Type}, {"EST_REMUN", type text}, {"ENERGIA", type number} , {"NODE_PRICE", Int64.Type}, {"PR_REM_ENERGIA", type number}, {"SMEC", type text}, {"POT_DISP", type number}, {"POT_OPE_CPO", type number}, {"SPOT_BUY ", type number}, {"SCTD", type number}, {"SCO", type number}, {"PIND", type number}, {"PINDPROG", type number}, {"PINDFORZ", Int64.Type }, {"POT_DISP_GAS", type number}, {"POT_DISP_RESERVA", type any}, {"NOMINATED_GAS", type any}, {"COST_406", type number}, {"REM_ADDICIONAL", Int64.Type}, {" DESP_ECON", type text}, {"CCM", type any}, {"CFO", type any}, {"CGN", Int64.Type}, {"CGO", Int64.Type}, {"POT_DISP_R19", type number}, {"FACTOR_KM", Int64.Type}, {"REPRESENTATIVE_TIME", type text}, {"ENERG_GEN_TRANSAC", type number}, {"ENERG_OPE_TRANSAC", type number}, {"OVERC_FORZ_OWN", type any}, {"PGENE_RES354", type any}, {"CGU_OWN", type any}, {"CGU_MEM", type any}, {"CGU_GAS_CEDIDO", type any}})
= Table.ReplaceValue(#"Type changed",".mdb","",Replacer.ReplaceText,{"Source.Name"})
= Table.ReplaceValue(#"Replaced Value","PO","",Replacer.ReplaceText,{"Source.Name"})
= Table.AddColumn(#"Replaced value1", "Date", each Date.FromText([Source.Name],[Format = "yyMMdd"]))

 For me its weird cause the information really loads in the power query editor, i´ve read that it could be a relationship thing but i have delete al the relationships and every aditional table and just wont work, i´´ve tried clearing the cache as well,

thanks for any help