Connection was denied because Deny Public Network Access is set to Yes.

Hi @Chun Hanssen,

it looks like you're running into an issue with connecting to your Azure SQL Database due to the "Deny Public Network Access" setting being activated. When this setting is set to "Yes," it prevents connections from public endpoints, which is why you're seeing that error when trying to access it from Power BI.

Here’s how you can resolve this:

Option 1: Configure a Private Link

1. Set Up a Private Endpoint: This is the recommended approach for security compliance. You will need to create a private endpoint in your Azure Virtual Network (VNet).
   • How to Configure Private Link
2. Connect through Private Endpoint: Ensure that your services accessing the SQL Database, including Power BI, utilize this private link to stay within the secure boundary.

Option 2: Allow Public Network Access

If you wish to access the SQL Database from Power BI without configuring a Private Link, you can change the public network access settings:

1. Access Azure Portal: Go to your SQL Database in the Azure Portal.
2. Networking Settings: Navigate to the Networking section.
3. *Change Public Network Access Settings: Switch Public Network Access to **Selected networks.
4. Add Firewall Rules: Add the necessary IP ranges for Power BI to connect. Make sure to include the relevant Azure service tags if you decide to allow access.

Additional Configuration

• If you are frequently using Azure services that need to access this server, it might be useful to check the setting "Allow Azure services and resources to access this server." This can assist in allowing access to the SQL Database without needing to individually whitelist IPs.
  • More details can be found in this documentation.

Summary

To connect Power BI to your Azure SQL Database, either set up a private link for secure communication or adjust the public network settings to allow specific IPs.

Let me know if you have any more questions or need further assistance!