Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
I have made a copy/paste of a query from Power BI Desktop (which works well) to Dataflow.
On Dataflow environment I have a new error : "Error: DataFormat.Error: We couldn't parse the input provided as a Date value."
I have two date columns and tens of millions of rows coming from 150 csv files... so it is very difficult to understand where is coming the error from. I tried to modify regional parameters but it is not the solution.
This error is not blocking the query steps, it only appears while refreshing the data...
Any idea how to fix this?
Thank you very much.
Raphaël
Solved! Go to Solution.
Hi @Raph
Could you show me a simple example with only date columns and the query you paste?
Best Regards
Maggie
Dear @v-juanli-msft & @AlB
Thank you for your answer. After havong done a long search, it appeared that that 2 csv files were kinf of "corrupted" when I copied pasted them on sharepoint... some lines were replaced by strange symbols. So I fixed this and thought everything was OK but now the dataflow refresh fails because of :
Error: Refreshing an entity exceeded the 2 hour refresh limit.
I don't know if it will be possible to fix this new error.
Thanks again
Raphaël
Hi @Raph
Can you see/find the piece of data that causes the error?
Have you checked that you have the right locale set in Dataflow? Is it hte same as in PBI?
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.