PowerBI service not connect in Postgressql

[avolio]

Hello,

I created some reports on power bi desktop connecting to postgresql online. When trying to visualize the realtorios in powerbi service, the database does not connect in postgres.

Image error:

Everything works on porwerbi desktop, but on powerbi service it doesn't work for nothing

[v-luwang-msft]

Hi @avolio ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft]

HI @avolio ,

The option was actually under the advanced settings of the dataset that was added to the gateway.

And  tried to upgrade to the latest version if you are using the on-premises data gateway.

to learn more details ,refer:

Power BI connection problem with Postgresql

PostgreSQL data source using encrypted connection when published?

Installing Power BI Data Gateway For Refresh of PostgreSQL Database

Wish it is helpful for you!

Best Regards

Lucien