Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
27 | |
26 | |
23 | |
21 |
User | Count |
---|---|
57 | |
41 | |
24 | |
24 | |
21 |