Date/Time data tipe values in error

Question

Hi,&nbsp;&nbsp;I'm building a report where I need to filter my visuals by the date and time a sales document was created on. I extract this information exactly the same everyday and upload it to powerbi without changing it. This info is provided by 2 different columns - document date and creation time - which I merged into one on PowerBI and set it with data type Data/Time.I've been using this column with no issue for a month and this week it suddenly shows half of the values in error due to&nbsp;"DataFormat.Error: We couldn't parse the input provided as a DateTime value". Example of a value in error: 4/13/2021 9:00AMI made no changes to the data format of the 2 original columns and the values are uploaded exactly the same, so I'm doing everything the same but now I can't fix this issue.&nbsp;&nbsp;Anyone knows what I can do to revert this?&nbsp;Thank you&nbsp;

amitchandak · Answer

Anonymous , is this date format is different from what you were getting in past?
Is you default date format dd/mm/yyyy and you start getting the mm/dd/yyyy
&nbsp;
Open power query and check for additional error details

anonymous · Answer

No, the date format is the same - mm/dd/yyyy - as it was before the error. I checked in a copy of the same file and all date formats are the same but only one of them shows the error after the refresh of the data. And the data is uploaded from the same source.

The details of the error on power query are what I wrote above in bold, it seems to be that time is showing before the date but I didn't change that, if this makes sense.

Thank you for your help

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
According to this similar thread,&nbsp;it seems like PowerBI Service expect date mm/dd/yyyy format until there is a way to change locale in powerbi service.
&nbsp;

&nbsp;
Best Regards,Eyelyn QinIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;&nbsp;I changed the date format in my excel source to mm/dd/yyyy and did the same in Power BI and still gotthe same error in Power Query. Then tried to get this field by using the concatenate function in the Data tab and got the same error.&nbsp;Thank you

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
You could right-click the column, then Change type --&gt; Using Locale --&gt; Select the correct format (is same as th original data) like this:

Best Regards,Eyelyn QinIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Date/Time data tipe values in error

8 Replies

Related content

Power BI service error - Date time format

Date/Time

Null value error

Calculate difference between two date/time values

date/time addition