Forum Discussion
Encoding numbers to text
Hello, I have a unique situation where most of my values are coming in as their actual text value, but some are being decoded as a numeric value. For example, 12345 would be encoded as MTIz...
Hi Anonymous
In power query, set the data type of the "value" column to be "any".
Best Regards
Maggie
Hi Maggie,
Thank you very much. I will try these solutions and will let you know how I make out.
Regards,
Pete
When I tried the above solution, the values within my custom column are all set to FALSE, even the numeric values.
Hi Anonymous
In power query, set the data type of the "value" column to be "any".
Best Regards
Maggie