Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
PowerBI88
Helper III
Helper III

DataFormatError:it was not possible to analyze the input specified as value Date

Hi,

I am getting the foolowing error when I try to perform a merge between 2 tables:

DataFormatError:it was not possible to analyze the input specified as value Date

 

Any hint on how to solve it?

 

Thank you

Kind regards

Marta

 

7 REPLIES 7
v-yetao1-msft
Community Support
Community Support

Hi @PowerBI88 

If your date is in two formats, merging may cause problems.

I currently have no way to restore your problem. If possible, can you provide your pbix file so that we can better analyze the problem ?

 

Best Regards

Community Support Team _ Ailsa Tao

PowerBI88
Helper III
Helper III

PowerBI88_0-1627028263007.png

 

@PowerBI88 , it showing 16% rows with error, can you check that

I replaced the errors with a date that I made up, but I keep getting the same problem when I perform a merge

PowerBI88
Helper III
Helper III

Could it be caused by null values in date field?

@PowerBI88 , if null is text then it can cause. or you have a date in two formats(Means data type in not date).

 

First check data type and make sure both are date or datetime

how do I check? the whole column is market as Date but it contains also null and it says that there are errors.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.