Forum Discussion
Expression Error: We cannot convert the value 5895 to type Text.
This error randomly started showing up on multiple Power BI dashboards I maintain. I am not sure why that is since I've checked the columns of the query in question and cannot find the '5895' value. ...
edhans
Community Champion
Community ChampionIn the query you are expanding, remove any Changed Type steps so it comes across as Any, or ABC/123. Then look at the expansion, and filter for data that is 5895.
After you find and fix it remember to put the Changed Type step back. Never let the ANY data type persist to the model.