Forum Discussion
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 ...
The fix for me was determining which fields had no values -- all values were null. And then changing the null value to a blank did not work - had to put in a text value of 'NA' and then use power BI replace value to change the "NA" back to a blank/null. Seems that if no data (or all blanks) is in a field with the redshift connector it defaults it to an integer value ... Boo!!