Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

New Member

Refresh DataSet Issue on powebi service

hi team,


I am facing Issue while refreshing the datasets in powerbi service published from powerbi desktop. I first tried using Onpremise Data Gateway. In this, I setup the Onpremise Data Gateway and set it with my dataset. Here the issue is, it is doing the dataset refresh but I need to enable the VPN (which is used to access the private subnet azure postgresql server database). Incase, I am not enabling the VPN , then I am getting below error:
{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"ODBC: ERROR [08001] timeout expired\n"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Odbc"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"dsn=PostgreSQL35W"}},{"code":"Microsoft.Data.Mashup.ValueError.OdbcErrors","detail":{"type":1,"value":"#table({\"SQLState\", \"NativeError\", \"Message\"}, {})"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}
My requirement is not to enable the VPN

The connection of Powerbi Desktop to Private Azure Database Server is made using psql odbc driver. 
Secondly, I also tried using Virtual Data Gateway. For this I followed the steps mentioned in official document given below:


Here I was able to follow all the three steps. After this when I am configuring the dataset with the virtual data gateway, it says it cannot be added to gateway 



When I click on this and try to create the connection for Virtual Data Gateway, it says that the credentials are invalid; which is false.
Could you please suggest me on this

Community Support
Community Support

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.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors