Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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
-
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |