Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Date column format error

    Posted 26 days ago
      |   view attached

    Hi everyone,

    While trying to import data source from excel, as of the attached data. When ever import the data to the power bi is presents this error message:

    DataFormat.Error: We couldn't parse the input provided as a Date value.
    Details:
    2/29/2021

    Here is what I have tried:
     
    • I have changed the data type using locale with data types of English(UK) sample: 29/03/2022 and English(US) sample: 03/29/2022, none helped.
    • I have also, splitted the column to three columns and remerged, and still not working.
    Only part of the data (where the ProductKey = 2494), is showing the error.

    Any help.

    Thank you in advance.

    ------------------------------
    Abdi Amed
    ------------------------------

    Attachment(s)

    xlsx
    Sales_data.xlsx   1.59 MB 1 version


  • 2.  RE: Date column format error
    Best Answer

    Posted 25 days ago
    Olá
    Em fevereiro de 2021, o mês foi até o dia 28, e no seu arquivo tem uma data que foi até o dia 29.

    ------------------------------
    Vilmar Santos
    ------------------------------



  • 3.  RE: Date column format error

    Posted 25 days ago
    I believe that is because 2/29/2021 is not a valid date.  2021 was not a leap year, therefore, the 28th was the last day of the month.

    ------------------------------
    Bill Brummett
    BI Developer
    ------------------------------