Forum Discussion
Anonymous
8 years agoNot applicable
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...
- 8 years ago
Hi Anonymous
In power query, set the data type of the "value" column to be "any".
Best Regards
Maggie
Anonymous
8 years agoNot applicable
Hi Maggie,
Thank you very much. I will try these solutions and will let you know how I make out.
Regards,
Pete
Anonymous
8 years agoNot applicable
Anonymous https://www.thebiccountant.com/2016/05/22/multiple-replacements-in-power-bi-and-power-query/