Forum Discussion
What IP adderss does Power Bi uses to pull the data from Azure SQL database
Hi anigam-proofpt ,
The IP address of Power BI Service can be different each time within each region as Power BI Service is a cloud-based service. You can download Microsoft Azure Datacenter IP Ranges and add required IP range based on your region in your firewall rule.
However, the IP range list is updated weekly, you would need to monitor it and make appropriate changes in your firewall rule.
Another method is to take advantage of gateway as described in this blog.Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Solution Supplier
Are you using On-Premises gateway with your PowerBI report or how is your dataset trying to connect with Azure SQL database?
Azure IP ranges are varied and there is no fixed IP ranges but you can view it based on regions from here:
https://www.microsoft.com/en-us/download/details.aspx?id=56519