Azure Database for PostgresSQL scheduled refresh in Power BI Services

Hi ,

I am using Azure Database for PostgreSQL as my data store and connecting it to Power BI to create report. The connection is working fine in Power BI Desktop. But on the power Bi service it is giving me below error.

"Failed to update data source credentials: The credentials provided for the PostgreSQL source are invalid. ( Source at <>.)"

This is weird as i am using the same credentials on Power BI Desktop.

I read in some of the thread it is advised to use the data gateway but those are disable as this is cloud data soruce.

has somebody tried to connect Azure PostgreSQL ?