Forum Discussion
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
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
