Forum Discussion
Text.PositionOf not working
Hi, Up until the 3/9/21 I had a query that used the Text.PositionOf function to return the position of an underscore in a text field. Since then, it's generating an error stating that an invalid ...
For me, it ended up to being an issue of source column being in the wrong datatype.
PowerBI incorrectly showed the datatype of source column being text.
For some reason, using source datatype, or
duplicating the source datatype and typing the data in the same step will not work.
Got it to work by duplicating source column and reassigning the text datatype to it in a separate step.
If i would have to guess, this could be caused by source data codepages <--> query optimization...?
Leaving this here, if someone happens to run across the same issue in the future.