Forum Discussion
Freya
3 years agoRegular Visitor
PowerBi Dekstop with connection to Postgresql with Python (transform data)
If I try the python script below (sql that aggregates the data of one table in a postgresql database) I get errors. If I try the same script but with Juypter it runs fine. I think there is an issue...
Anonymous
3 years agoNot applicable
Hi Freya,
Perhaps you can take a look at the following link about the similar issue to remove the quotes from Enterprise_nbr field that you used in group by function.
python - Non-integer constant in GROUP BY - Stack Overflow
Regards,
Xiaoxin Sheng