Date value changes to text on refresh of Power Query data - only for Excel 365
I have an issue where my date columns are transforming to numbers and defined as 'general' when I refresh the data. I've tried formatting the entire column as date and saving the file. The next time I open the report and refresh the dates are converted to it's numerical equivalent. In Power Query, the columns are seen as Date/Time; therefore, I changed it to 'Date' to see if the Time portion could be causing a problem. That did not help. I'm at a loss as to what the issue is. This does not happen with Excel 2013. I can't find any settings in Excel 365 that might be causing this.Power Query Refresh from Folder
I receive daily .csv files via e-mail (unfortunately I can't access the original source). Each data file contains information for yesterday, today, and tomorrow. Therefore, the most accurate information is recorded for the earliest date for each data file. I am trying to create a query or multiple queries to pull data from multiple .csv files and be able to do the following: 1. Pull the earliest date from EACH file and de-dup some rows based on criteria. I tried doing this, but it seems to pull the earliest date not by file, but from all the .csv files. So, if I wanted the 2 Feb from one file and 3 Feb from another, it's only pulling the "earliest" from both (2 Feb). 2. Refresh ONLY new .csv files I add to the folder. I need to manually go through some of the rows and delete due to issues from the data source, so when I refresh I don't want it to run through the other files. Thoughts? I was thinking maybe there's a way to create a table and append it with the new data somehow, but I get stuck in the process. Thanks!