Connection only query not refreshing correct date filter

Question

I have a connection only query that is not refreshing with the correct date e.g. should be updating with Apr-22 and I cannot see where I am going wrong or is it likely to be the table is actually not refreshing?

Let
   Source = Excel.CurrentWorkbook(){[Name="NewAccrualData"]}[Content],
   #"Filtered Rows" = Table.SelectRows(Source, each [Division ID] <> "Dummy" and [Division ID] <> null and [Division ID] <> "Null" and [Division ID] <> "Total"),
   #"Changed Type" = Table.TransformColumnTypes(#"Filtered Rows",{{"Date", type date}, {"GL Code", Int64.Type}, {"Cost Centre", Int64.Type}, {"Amount", type number}}),
   #"Calculated End of Month" = Table.TransformColumns(#"Changed Type",{{"Date", Date.EndOfMonth, type date}}),
   #"Added Custom" = Table.AddColumn(#"Calculated End of Month", "Data Source", each "Record Accruals")
in
  #"Added Custom"