Hi, when I refresh with new data the date format is incorrect, see below in yellow. I have to select the columns and manually format as 'Date' in the excel worksheet after I refresh. I originally created the power query in MS 2016 and now use it in MS 365, could that be the problem? Thanks in advance.