Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Abdi Amed]

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
——————————

[Vilmar Santos]

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
——————————
——————————————-

[Bill Brummett]

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
——————————
——————————————-