How do we find Power BI endpoint IP addresses for cloud installation?

[Anonymous]

We recently installed Power BI cloud and we are having issues with Report refreshes. We get arrors similar to this below:

Microsoft SQL: Cannot open server 'sledison365prod' requested by the login. Client with IP address '40.80.188.51' is not allowed to access the server. To enable access, use the Windows Azure Management Portal or run sp_set_firewall_rule on the master database to create a firewall rule for this IP address or address range. It may take up to five minutes for this change to take effect."}}],"exceptionCulprit":1}}} Table: GamificationUsers.

Each failure gives us another IP address. How do we get a list of the Outbound IP addresses for PowerBI or should we be doing this some other way than adding IP's to our Azure portal?

Any guidance or direction would be appreciate.

Thanks. 

[lbendlin]

---

IP Ranges for each cloud, broken down by region and by the tagged services in that cloud are now available on MS Download: Public: https://www.microsoft.com/en-us/download/details.aspx?id=56519 US Gov: http://www.microsoft.com/en-us/download/details.aspx?id=57063 Germany: http://www.microsoft.com/en-us/download/details.aspx?id=57064 China: http://www.microsoft.com/en-us/download/details.aspx?id=57062 These JSON files are updated weekly and include versioning both for the full file and each individual service tag in that file. The “AzureCloud” tag provides the IP ranges for that entire cloud (Public, USGov, Germany, China) and is also broken out by region within that cloud. Finally, the list of service tags in the file will be increasing as we’re constantly onboarding new azure teams to service tags.

---