Forum Discussion
How can I prevent a Power BI data flow from automatically changing the data type of a column
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
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 _ PollyIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
And also when I change the data to tipe date my dataflow don´t refresh correctly
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 _ PollyIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
