Refresh DataSet Issue on powebi service

Hi dinesh_jui ,

It seems like you are facing issues while refreshing the datasets in Power BI service published from Power BI Desktop. You have tried using On-premises Data Gateway and Virtual Data Gateway, but you are facing issues with both.

Regarding the issue with On-premises Data Gateway, it seems like you need to enable the VPN to access the private subnet Azure PostgreSQL server database. If you do not enable the VPN, you are getting an error. If you do not want to enable the VPN, you can try the following steps:

• Check if the firewall rules are configured correctly to allow access to the private subnet Azure PostgreSQL server database.
• Check if the ODBC driver is installed correctly on the machine where the On-premises Data Gateway is installed.
• Check if the connection string is correct and the credentials are valid.

Regarding the issue with Virtual Data Gateway,you can try the following steps:

• Check if the credentials are correct and have the appropriate permissions to access the data.
• Check if the Virtual Data Gateway is installed correctly and is running.
• Check if the connection string is correct and the credentials are valid.

If it does not help, please provide more details.

Best Regards
Community Support Team _ Rongtie

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