Share via

[DataFormat.Error] We couldn't parse the input provided as a Date value.

Anonymous
2023-12-04T17:18:02+00:00

Hi,

I have refreshed my dataset every week with the same flow, but today I have received the error in attouch.

I have tried to find out the error in editing the query, but no error was found.

I have a dataset create with different cvs and the data model takes the data from the cv imported every week.

[DataFormat.Error] We couldn't parse the input provided as a Date value.

Could you help me?

thanks

Microsoft 365 and Office | Excel | For business | Android

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-12-04T17:33:56+00:00

    Check the date format in your source data and make sure it is in a recognized format.

    You may try.

    1. Next Right click on the Field/Column you want to convert into a Date Field and navigate to 'Change Type' .

    Change_type.png

    1. Next Click on 'Using Locale' option under the 'Change Type' dropdown.

    Using_locale.png

    1. Change the 'Data type' to 'Date' in the dialog box of 'Using Locale' 

    date_as_datatype.png

    1. Click on the drop down of 'locale'.

    Locale_Drop_down.png

    1. Then Select an 'Option' from drop down for which your Date field  'Format' matches exactly and Click on 'OK' . 

    Format.png

    Reference:

    Solved: DataFormat.Error: We couldn't parse the input prov... - Microsoft Fabric Community

    Was this answer helpful?

    0 comments