PowerBI Service Dataset refresh issue : PostgreSQL: 42883: operator does not exist: boolean = intege

[stacquet]

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

[Hariharan_R]

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...

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