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...
That is a Power Query formula. Click on "Edit Queries" and find the query with your table of information. Select "Add Column" in the ribbon and find "Custom Column". There is a box for the column name and then a box for that particular formula. Once you click ok, you'll see a new version of the table with an attempt at processing the formula. Any errors will be displayed and you can tweak the formula to get it correct.
Close and Apply will attempt to import your data again with this new column included.
I'm resorting to trying to go back to the source data and fix at that end......