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
Anonymous
Not applicable

DataFormatError

Hi,

 

in my table, I have 3 columns as shown below, I already set datatype's of Dataset as text, Date as date/Time and Country as Text.

 

Dataset    Date                         Country 

ABC      01/01/2020 00:00:00    Austria

BCD      01/01/2020 00:00:00    Belgium

CDE      02/01/2020 01:00:00    Denmark and so on.....

 

Later When I am trying to filter the dataset column, it gives me an error saying,  [DataFormat.Error] We couldn't parse the input provided as a DateTime value. I dont understand why is this, even though the datatype of dataset is text!! It would be great if anyone can suggest anything.

 

TIA

 

2 REPLIES 2
v-xulin-mstf
Community Support
Community Support

Hi @Anonymous,

 

According to the error messages, you can check the format of Date column.

If the issue still exist, please provide more details, such as sample data, screen shots, etc.

 

Best Regards,

Link

PC2790
Community Champion
Community Champion

Hello,

 

Can you please brief on the steps that you are doing when you say -trying to filter?

A screenshot would be helpful

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.