Forum Discussion
Power Query Changing Text Characters to Symbols
Hi, I'm facing a very weird problem. I have a PBI report where my source is from an Excel file. In the file, there is a column (Huawei cell Name) that has some values like "DHK_X0034_1", "DHK_X2267_...
As advised, the best course of action here was to post this in the Issues forum where it was seen by the MS team on the Powery product, where it was fixed by the May 2021 release. marking this as the solution to this thread can be seen as solved.
just an observation (which does not solve the enigma) to give some element of further reflection.
- the string x0034 intended as a hexadecimal number is 42 which is the charcode of the "symbol" 4;
- the string x02267 intended as a hexadecimal number is 8807 which is the charcode of the symbol ≧;
- etc.
try reading these strings from an excel file
| _X0030_ |
| _X0031_ |
| _X3456_ |
| _X4532_ |
| _X2267_ |
| _X4532_ |
| _X2367_ |
| _X1332_ |
| _X2467_ |
| _X4509_ |