Forum Discussion

Grivil's avatar
Grivil
Regular Visitor
3 years ago

Three Different Date Formats in a Column

Hi everyone,    I'm trying to load a pretty large csv file  (~400mb) into Power BI. I encontered that my data has different formatting for a specific row. Is there a way for me to make the data uni...
Need Help
ronrsnfld's avatar
ronrsnfld
Super User
3 years ago
  • Get Data from Text/CSV
  • Transform Data
  • In Power Query, right-click on the date column
    • Change Type
      • Using Locale
        • Select something like "English (Europe)"
  • Then you can load it back to Power BI

If that doesn't work, please open the CSV file in a text editor like Notepad or Notepad++, and copy/paste some representative data as text. Be sure to obfuscate any confidential information

  • Grivil's avatar
    Grivil
    Regular Visitor
    3 years ago

    i tried that already, excel is giving mw a hard time editing the data as well. 


    I don't have access to my device right now, but the screenshot i showed you is the actual data. It's basically timestamps. With different formating for certain dates. 

    • ronrsnfld's avatar
      ronrsnfld
      Super User
      3 years ago

      What you are showing is NOT the actual data. What you are showing is the result of opening the csv file in Excel. But if you are unwilling to show the actual data I will not be able to assist.