cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GovindM
Helper I
Helper I

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 @GovindM,

 

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
Solution Sage
Solution Sage

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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors