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 dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
How do I solve this? This error happened after I refreshed the data for the dataflow that was working properly before.
DataFormat.Error: We Couldn't parse the input provided as a date value
Details:
,,,,,,,,,,,,Bal,,,
The error seems to be at a step where I am combining two queries based on a common ID in both. However, neither were nor are a Date or in that format.
Look at your data again. In you dataflow do a test with a subset (top 1000 rows for example). Then isolate the data row with the format issue and decide how to handle that.
User | Count |
---|---|
8 | |
6 | |
6 | |
5 | |
5 |
User | Count |
---|---|
9 | |
8 | |
6 | |
6 | |
6 |