Refresh of Azure SQL DB failing from powerbigov.us

[samgreene1]

Hi,

I have a Power BI tenant in the US government area - powerbigov.us.

In our Azure SQL DB Server I've enabled "allow azure services and resources" , but still get a firewall error when refreshing.  

Is there any way to get this to work or do I have to use the VM/Gateway option?

Thanks,

Sam

[samgreene1]

I found this while doing some training - service-tags .  Seems like it might be a good option.

[Anonymous · Accepted solution]

Hi  @samgreene1 ,

1. Please add firewall rules to specify which IP address ranges from the Internet are allowed. See: Azure SQL Database server-level and database-level firewall rules.

2. Please check if the outbound traffic over port 1433 port is allowed on the machine which has desktop runs.

3. Please check if your Azure SQL is behind a firewall, VPN is required, or on a virtual network. If it is, a data gateway is required.

Reference:

On-premises data gateway FAQ

Important considerations when using DirectQuery

4. You can follow Troubleshoot connecting to the SQL Server Database Engine  to check the problem.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.