Connectivity
Connection denied: Deny Public Network Access (Azure SQL)
Power BI dataset refresh error: what it means and how to fix it.
What this means
Azure SQL is blocking public-endpoint connections.
How to fix it
- Use a private endpoint with a VNet data gateway.
- Or allow Selected networks and add the Power BI service-tag IP ranges.
Frequently asked questions
- What does the "Connection denied: Deny Public Network Access (Azure SQL)" error mean?
- Azure SQL is blocking public-endpoint connections.
- How do I fix it?
- Use a private endpoint with a VNet data gateway. Or allow Selected networks and add the Power BI service-tag IP ranges.
- Where does this Power BI refresh error appear?
- It appears in a Power BI semantic model's refresh history when a scheduled or on-demand refresh fails.
Related connectivity errors
Catch this automatically
RefreshRadar monitors every Power BI dataset refresh and emails you when one fails, with the likely cause and the fix, so you are not hearing about a broken refresh from your stakeholders first.