Power Query inserts wrong dates to Excel
Hello,
I am trying to connect an external CSV-file and parse the data into Excel, so that I can use it there. The CSV-file contains one column of timestamps in the format of “yyyy-MM-dd hh:mm:ss”.
I am able to load the data no problem, but I want to transform it before it is inserted into Excel, so that it is easier to work with. Though, when I seem to do my transformation in power query, the column of type date changes when I load the data into Excel. (See attached photo)
I believe the issue could be due to different locale and region settings, but I have gone over and check everywhere on my computer, my MacBooks settings, excel workbook settings and power query settings, and they are all set to Denmark (da-DK).
I have also tried making a column where I converted the date to plain text, and it seems to get the dates fine there. For some reason, when it is loading the data into Excel, it parses the date completely wrong, and the date value is off by almost 2000.
Any help on this problem is much appreciated.
Hello, I am trying to connect an external CSV-file and parse the data into Excel, so that I can use it there. The CSV-file contains one column of timestamps in the format of “yyyy-MM-dd hh:mm:ss”. I am able to load the data no problem, but I want to transform it before it is inserted into Excel, so that it is easier to work with. Though, when I seem to do my transformation in power query, the column of type date changes when I load the data into Excel. (See attached photo)I believe the issue could be due to different locale and region settings, but I have gone over and check everywhere on my computer, my MacBooks settings, excel workbook settings and power query settings, and they are all set to Denmark (da-DK).I have also tried making a column where I converted the date to plain text, and it seems to get the dates fine there. For some reason, when it is loading the data into Excel, it parses the date completely wrong, and the date value is off by almost 2000. Any help on this problem is much appreciated. Read More
