What causes SqlDeniedPublicAccess?

The Azure SQL Database has "Deny public network access" enabled, and the Azure IR is attempting to connect over the public internet. A Managed Private Endpoint has not been configured in ADF for the SQL Database. A self-hosted integration runtime is being used but its outbound IP is not in the SQL firewall allowlist

How do I fix SqlDeniedPublicAccess?

If using Azure IR: create a Managed Private Endpoint in ADF for the Azure SQL Database or Synapse workspace.. If using self-hosted IR: add the SHIR machine's outbound IP to the SQL Database firewall rules, or connect via a VNet integration.. Alternatively, re-enable public access on the SQL Database and restrict by IP instead of disabling it entirely.. Verify the private endpoint DNS resolution is working correctly from the integration runtime.

High severitydata source

Power BI Refresh Error:
SqlDeniedPublicAccess

What does this error mean?

ADF cannot connect to Azure SQL Database or Synapse Analytics because public network access is disabled and the integration runtime is not routed through the private network.

Common causes

1The Azure SQL Database has "Deny public network access" enabled, and the Azure IR is attempting to connect over the public internet
2A Managed Private Endpoint has not been configured in ADF for the SQL Database
3A self-hosted integration runtime is being used but its outbound IP is not in the SQL firewall allowlist

How to fix it

1If using Azure IR: create a Managed Private Endpoint in ADF for the Azure SQL Database or Synapse workspace.
2If using self-hosted IR: add the SHIR machine's outbound IP to the SQL Database firewall rules, or connect via a VNet integration.
3Alternatively, re-enable public access on the SQL Database and restrict by IP instead of disabling it entirely.
4Verify the private endpoint DNS resolution is working correctly from the integration runtime.

Frequently asked questions

Does this error affect all pipeline runs or just the current one?

Depends on the root cause. A persistent misconfiguration fails every run; a transient issue may resolve on retry. Check the run history.

Can this error appear in Azure Data Factory and Microsoft Fabric pipelines?

Yes — the same connector errors appear in both ADF and Fabric Data Factory pipelines.

How do I see the full error detail for an ADF pipeline failure?

In ADF Monitor, click the failed run, then the failed activity. The detail pane shows the error code, message, and sub-error codes.

Will downstream Power BI datasets be affected when an ADF pipeline fails?

Yes — a dataset refreshing after the pipeline will use stale data or fail if the target table was cleared. The Power BI refresh may succeed while serving wrong data.

Official documentation: https://learn.microsoft.com/en-us/azure/data-factory/connector-troubleshoot-synapse-sql