Forum Discussion
PowerBI Service Dataset refresh issue : PostgreSQL: 42883: operator does not exist: boolean = intege
Hello,
I have a dataset in PowerBI Service that refresh every morning on an Azure Postgresql Database.
Since 10/06, refresh is not working with the following error : PostgreSQL: 42883: operator does not exist: boolean = integer
However, refresh with the same dataset with desktop, pointing on the same Azure Postgresql Database is fine.
No changes have been made on the structure of the datasource.
Do you have an idea of what is happening ?
Best Regards,
Sylvain
1 Reply
Hi,
Are you trying to pass a value either 1 or 0 on boolen field? You need to say True or False instead of 1 or 0
Please refer below thread - https://stackoverflow.com/questions/66085915/on-data-migration-getting-error-operator-does-not-exist-boolean-integer-hin
Thanks
Hari
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
My Blog :: YouTube Channel :: My Linkedin
