How can I prevent a Power BI data flow from automatically changing the data type of a column

[Line14Garr0]

Hi, I'm creating a dataflow that consolidates several files with dates, but my problem is that the dataflow is automatically changing those dates to text type, which affects my data. Does anyone have a solution for this?

Thanks

[Anonymous · Accepted solution]

Hi @Line14Garr0 ,

You may try Json.FromValue - PowerQuery M | Microsoft Learn and Binary.ToText - PowerQuery M | Microsoft Learn to convert it to String data type, then use Binary.FromText - PowerQuery M | Microsoft Learn and Json.Document - PowerQuery M | Microsoft Learn to convert it back.

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Line14Garr0]

And also when I change the data to tipe date my dataflow don´t refresh correctly