Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Date format conversion Issue

Hi All,   My Excel has Date format in the form of MM/DD/YYYY , When i import excel in Power BI Desktop, Date gets converted to DD/MM/YYYY. I have used "Locale" setting in my desktop as English (Un...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    Anonymous

     


    My Excel has Date format in the form of MM/DD/YYYY , When i import excel in Power BI Desktop, Date gets converted to DD/MM/YYYY.

     

     

    I doubt it is not a valid date type in excel. The "dates" located left most in a cell are actually not date, while the right part are.

     

     

    Based om my test, the valid dates(B column) are never affected by locale. While the the A column are predicated differently according to locale. You can remove the applied change type step and change the A to a date via locale in query editor.

     

     

     

KGrice's avatar
KGrice
Memorable Member
10 years ago

That does sound odd. Is Power BI converting only the formatting? If you manually adjust the formatting back to MM/DD/YYYY does it give you any issues? Making sure it's not somehow converting the number itself. Can you tell that the data type is Date and not Text or something else?