Forum Discussion

FlorianF's avatar
FlorianF
Frequent Visitor
3 years ago
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...
Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

     

    Ok, update the highlighted section to be:

    each try f_archivedEmails([id]) otherwise null

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
3 years ago

Hi FlorianF ,

 

I don't think you'll see a null in your filter list in this scenario as the cell won't be null, it will be an error value.

Try selecting your [company] column then go to the Home tab > Keep Rows > Keep Errors.

Hopefully this will leave only the rows with errors which you can review/troubleshoot as required.

 

Pete