Error in Scheduled refresh for data source Postgresql

[sayali_deshmukh]

Hi,

Connected to postgresql using ODBC drivers.

Unable to schedule refresh without having to use a gateway.

Can anyone help for a way to connect to postgresql so that scheduled refresh can be used?

[v-lionel-msft]

Hi @sayali_deshmukh ,

You can directly use the Postgresql connector in PBI Desktop.

And you need to configure the gateway for the dataset in PBI Service.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sayali_deshmukh]

Hi @v-lionel-msft 

Looking for a way to connect to postgresql without having to use the Gateway.
Getting following error -

[v-lionel-msft]

Hi @sayali_deshmukh ,

There is no such a method that allows you to refresh the postgresql  without using a gateway in current version(13.0.13248.257).

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.