PostgreSql Database

[Anonymous]

Hi to everyone, i my navigation with PostgreSql Db and Powerbi Desktop. When i set connection i must remove the flag 

after publishing, i cant update my data set because i can't set that option on-line. How can i do to solve it?

[Anonymous]

Thanks Jing, the error is

i wouldn't use ODBC connection, if it's possible...

I don't find solution

Thanks a lot

[v-jingzhang]

Hi @Anonymous 

What error message did you get from Power BI Service? 

Maybe you can try using on-premises data gateway to configure the PostgreSQL data source. I found a similar issue from below link and the user used gateway to get it worked.

https://stackoverflow.com/questions/63664474/power-bi-connection-problem-with-postgresql

Regards,
Community Support Team _ Jing Zhang