Reply
samgreene1
Resolver I
Resolver I

Refresh of Azure SQL DB failing from powerbigov.us

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

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

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

vyangliumsft_0-1626939133907.png

Important considerations when using DirectQuery

vyangliumsft_1-1626939133909.png

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.

View solution in original post

2 REPLIES 2
samgreene1
Resolver I
Resolver I

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

v-yangliu-msft
Community Support
Community Support

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

vyangliumsft_0-1626939133907.png

Important considerations when using DirectQuery

vyangliumsft_1-1626939133909.png

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.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)