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.
Hi all,
I keep on getting this [DataFormat.Error] We couldn't convert to Date. every time I refresh my data on Query Editor.
It appears even when selecting Text Columns (I had previously appleid only conversion to text format for that column).
I think this is a bug.
Please see attached images.
Many thanks for oyur time.
In PowerQuery, filter the date field with "Keep rows with error" then check the error
Hi @rsdondo
Are you importing from an excel?
If so, it could be that the error is coming from a symbol that someone entered manually in the excel. Before the step where it is converted in Power Query, sort the column from A-Z and see if you can find such symbols, if you do, just highlight the cell and replace with null.
If it's a differnet source, please let me know and I will try help further
Joe
Proud to be a Super User! | |
Date tables help! Learn more
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
9 | |
8 | |
6 | |
6 | |
6 |