- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I found this while doing some training - service-tags . Seems like it might be a good option.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
04-03-2024 10:01 AM | |||
10-30-2024 04:55 AM | |||
09-26-2024 02:21 AM | |||
09-29-2024 07:03 AM | |||
06-22-2017 07:01 AM |
User | Count |
---|---|
55 | |
53 | |
49 | |
13 | |
13 |