DataFormat.Error after having copied a query from Desktop to Dataflow

[Raph]

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

[v-juanli-msft]

Hi @Raph 

Could you show me a simple example with only date columns and the query you paste?

Best Regards

Maggie

[Raph]

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

[Raph · Accepted solution]

It's OK, I managed to load the data in 1 hour 50 minutes... Thank you Raphael

[AlB]

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