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.

     

     

     

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
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.