Forum Discussion
Automate Service IP whitelisting
Yes, this can be automated. The simplest option is to use Azure Service Tags such as PowerBI in your firewall rules, which are automatically updated by Microsoft so you don’t need to maintain them manually. If your environment does not support service tags, you can still handle it with automation. A common method is to create a PowerShell or Azure CLI script that downloads the official Azure IP ranges JSON file, extracts only the Power BI IP addresses, and updates your whitelist. This script can then be scheduled to run every week using Task Scheduler, Azure Automation, or Logic Apps. By doing this, your firewall rules or network settings will always stay up to date without any manual intervention. In short, either rely on service tags for a hands-off solution or set up a scheduled script to refresh the IPs automatically.
Yes, this can be automated. The simplest option is to use Azure Service Tags such as PowerBI in your firewall rules, which are automatically updated by Microsoft so you don’t need to maintain them manually. If your environment does not support service tags, you can still handle it with automation. A common method is to create a PowerShell or Azure CLI script that downloads the official Azure IP ranges JSON file, extracts only the Power BI IP addresses, and updates your whitelist. This script can then be scheduled to run every week using Task Scheduler, Azure Automation, or Logic Apps. By doing this, your firewall rules or network settings will always stay up to date without any manual intervention. In short, either rely on service tags for a hands-off solution or set up a scheduled script to refresh the IPs automatically.