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
I added the function with the menu and selected the values here.
I do not know, how and where to implement the if statement.
Can anybody give me an example?
- BA_Pete
Super User
For your scenario, i.e. running the function as a source, you could try:
(Customer as number) => let Quelle = try Json.Document( Web.Contents( "https://ffbc.weclapp.com/webapp/api/v1/archivedEmail?entityId=" & Number.ToText(Customer) & "&entityName=party&pageSize=1000" ) ) otherwise null in QuellePete
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.
- BA_Pete
Ok, update the highlighted section to be:
each try f_archivedEmails([id]) otherwise nullPete