Forum Discussion
Error : Cannot convert value " of type Text to type Integer
Hi, Can someone please explain (in a non technical way) how I fix the above error I have data coming through sa listed below <div>116</div> <div>18</div> I'm unable to change the data s...
This conversation is pretty old, but it may be valuable for someone. I had the same problem, but the source for me was excel spreadsheet. In Query Editor everything was looking good, but in Power BI I had some blank rolls at the top. The blank cells were the problem for the error. VALUE() seems can't figure out what to do with empty strings like "".