Forum Discussion
type conversion function (used to remove accents) creates new errors
Hello, I have found this function on internet to remove accents : = (textToConvert) =>
let
textBinary = Text.ToBinary (textToConvert, 1251 ),
textASCII = Text.FromBinary...
I found the issue, Power BI had created a table relationship in my model that I hadn't asked for and it was base on an ID which had indeed one null value. So I can fix it by either removing my relationship in the model or by removing the null values in an additionnal Power Query step.
So my function to remove accents is OK.
I found the issue, Power BI had created a table relationship in my model that I hadn't asked for and it was base on an ID which had indeed one null value. So I can fix it by either removing my relationship in the model or by removing the null values in an additionnal Power Query step.
So my function to remove accents is OK.