Forum Discussion
Anonymous
6 years agoNot applicable
ERROR [22P02] [SQLState 22P02] ERROR: invalid input syntax for integer: ""
Hi all, Anybody familiar with this error message and knows how to fix this? data source is a table from Amazon Redshift, and the table is fine in redshift. we can do our queries and ...
amitchandak
6 years agoSuper User
Anonymous , Refer :https://community.powerbi.com/t5/Desktop/Error-quot-Cannot-convert-value-xxxx-of-type-Text-to-type/m-p/967516
or
Try to change that column as text and check if it works.
This is not a power bi solution but will give an idea