Forum Discussion
Solved
Error null cannot converted to text (but there is no null value in column)
Hi guys, I have a strange error in Power BI. It says that a null value cannot be converted into text. But the column where the error disappears is not a datatype text, and also there is no null val...
Ok, update the highlighted section to be:
each try f_archivedEmails([id]) otherwise nullPete
Sorry I was wrong.
The number always has a value. The error come up, when the result of the function is empty. So I have to check if the result is empty and go to the next and write empty string in the columns of the query I use the function.
I think at this point, where the function will executed I have to check if the result is empty and continue with the next number.
Ok, update the highlighted section to be:
each try f_archivedEmails([id]) otherwise null
Pete