Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I was also having the same issue but got the solution after some effort.
You can try converting your string into ASCII code into the query editor using M query.
Create a custom column in the query editor and convert your string letter by letter into relevant ASCII Code.
For example, a Column having the string = Product ID
Text.From(Character.ToNumber(Text.Middle([#"Product ID"],0,1))) &"|"&
Text.From(Character.ToNumber(Text.Middle([#"Product ID"],1,1))) &"|"&
Text.From(Character.ToNumber(Text.Middle([#"Product ID"],2,1)))&"|"&
Text.From(Character.ToNumber(Text.Middle([#"Product ID"],3,1)))
You will get ASCII code for your String separated by "|" letter by letter.
Now after loading in the BI table, Split the ASCII code by "|", and using UNICHAR decode the ASCII Code.
The method is a little typical but you will get the result.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.