Forum Discussion

Line14Garr0's avatar
Line14Garr0
New Member
3 years ago
Solved

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...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.