Date/Time data tipe values in error

[Anonymous]

Hi, 

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 "DataFormat.Error: We couldn't parse the input provided as a DateTime value". Example of a value in error: 4/13/2021 9:00AM

I 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. 

Anyone knows what I can do to revert this?

Thank you

[TimOShea]

I am having the same issue. 
Sample date value is 

2024-04-04 16:00:03 BST

If i set to change type using Locale, Date/Time/Timezone with Locale set to English (United Kingdom) i get 'Error'.
Before timezone change sample

2024-03-25 14:00:47 GMT

is imported correctly. 

[Anonymous]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @Anonymous , 

Thank you for your help, but it didn't solve the issue. I did it by adding a new column in my excel file.

Thank you again

[Anonymous]

Hi @Anonymous ,

You could right-click the column, then Change type --> Using Locale --> Select the correct format (is same as th original data) like this:

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

[Anonymous]

Hi @Anonymous ,

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

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

[Anonymous]

Hi @Anonymous , 

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.

Thank you

[amitchandak]

@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

Open power query and check for additional error details

[Anonymous]

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