Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
sid5233
New Member

V net data gateway fail to refresh the dataflow after some time

I have created 'Cross Tenant' a v-net data gateway for my Synapse analytics dedicated SQL pool from my Powe BI Portal. Gateway is in the same network where the dedicated synapse pool is. And my Synapse public network access is disabled. In Gateway configuration and data source it shows online status and they are also able to see the tables and everything but when the daily scheduled refresh occurs it fails and sometimes throws error : 

 

 

Error: Encountered user gateway exception: '[DM_ErrorDetailNameCode_UnderlyingErrorCode]=-214[DM_ErrorDetailNameCode_UnderlyingHResult]=-21259 [Microsoft.Data.Mashup.ValueError.Class]=14 [Microsoft.Data.Mashup.ValueError.DataSourceKind]=SQL [Microsoft.Data.Mashup.ValueError.DataSourcePath]=XXXXXX.sql.azuresynapse.net;XXXXXXXX [Microsoft.Data.Mashup.ValueError.ErrorCode]=-214 [Microsoft.Data.Mashup.ValueError.Message]=Reason: An instance-specific error occurred while establishing a connection to SQL Server. Connection was denied since Deny Public Network Access is set to Yes 

 

 

 

1 REPLY 1
Anonymous
Not applicable

Hi @sid5233 ,

It seems that you are having trouble connecting to your Azure Synapse Analytics dedicated SQL pool from Power BI service. One possible reason for this error is that you have disabled public network access for your Synapse workspace, which means you can only connect to it using private endpoints. If you want to use a gateway to refresh your data, you need to set up a gateway on a VM, whitelist the IP of that VM in the firewall rule, and use it to refresh the Power BI. Alternatively, you can enable public network access for your Synapse workspace and configure the firewall rules accordingly.

Solved: Re: Unable to connect my Azure Synapse Analytics (... - Microsoft Fabric Community

Power Query Azure Synapse Analytics (SQL DW) connector - Power Query | Microsoft Learn

Azure Synapse connectivity settings - Azure Synapse Analytics | Microsoft Learn

Azure Private Link - Azure SQL Database and Azure Synapse Analytics | Microsoft Learn

Power Query Azure Synapse Analytics (SQL DW) connector - Power Query | Microsoft Learn

 

 

How to Get Your Question Answered Quickly 

 

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

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.