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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
npate102
Frequent Visitor

DataFormat.Error: We couldn't parse the input provided as a date I know, but, how do I fix?

Alright. I know this has probably been posted a gazillion time here; but, I'm getting an error 

 

"DataFormat.Error: We couldn't parse the input provided as a Date value.

Details:

15-Oct-19*"

 

Now, as data is thousands of rows long, I can't check the data quality. If I sort it decending, it throws up an error obviously. I know that there's an error, and I want to solve it by removing that * at the end. but, how do I do it? It's not even letting me work on the error. 

 
1 REPLY 1
Anonymous
Not applicable

Hi @npate102!

 

I'd suggest 3 things:

 

- On Edit Queries, replace value * for nothing

- Create a example column only with value you mentioned 15-Oct-19, and then deleting the previous column

- Check source and get root cause 

 

Hope this helps 🙂

Barbara 

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.