Forum Discussion
Having problems with multiple date formats after last refresh
Hi ranz_vincent
When changing the data types, especially at the very beginning, always ensure that the culture is specified. Also, if you have any transformations that combines the date with another column, specify the culture as well.
en-AU and en-GB follows dd/mm/yy while en-US follows mm/dd/yy.
Hi ranz_vincent,
I would like to let you know that i was also faced samekind of issue sometime ago. Sometimes the date shows dd/mm/yyyy in csv/excel files but it's not a date. There is a way to debug the errors.
1. Identify the error row/s and just click on the erorr it will show what's inside the error at bottom of the query editor like below
2. Identify the data source file name for that specific error and go through that.
3. Check that data, is it in date format/date data type in csv/excel file. If the date is in genral or someotther format just chnage it.
Let me knwo if you have any questions.
Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.
the error that shows are formatted like this 13 01 2025 but in my csv files all my date columns are formatted as date and shown like that but when i try to check and change the first transformation of date columns to text in power query it shows multiple date formats some are yyyy-dd-mm,dd/mm/yyyy,dd MMMM yyyy is this normal? by the way my system region and pbi region are set to english philippines
Hi ranz_vincent,
YYYY-DD-MM, DD-MM-YYYY and DD MMMM YYYY all are normal as far as I know, one of my dataset having same formats. Also please let me know on what day/date data refresh you got errors.
Could you please provide the .pbix file for sample data of errors and let me know which source file it is. So that I will provide exact solution.
Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.