Forum Discussion

ranz_vincent's avatar
ranz_vincent
Icon for Helper I rankHelper I
1 year ago
Solved

Having problems with multiple date formats after last refresh

Hello I suddenly encounter a problem with date format after my last data refresh and I have been using this model since January 2025 and now all of a sudden my date columnns are saying that there are...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    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.

ranz_vincent's avatar
ranz_vincent
Icon for Helper I rankHelper I
1 year ago

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

ajaybabuinturi's avatar
ajaybabuinturi
Icon for Super User rankSuper User
1 year ago

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.