Whitelist PowerBI service FQDNs or IP ranges for Connectors to work

[rsmccall33]

I want to use the JIRA connector to procure custom reports in PowerBI.com service.

Two difficulties.  The first is that our Jira is sitting behind a WAP and requires MFA.  I don't see how I can possibly setup the JIRA connector in this setup.

The second, I was given a second external IP to use to connect to Jira.  However, I need to get through the firewall which means I need to whitelist the FQDN or IP range that the PowerBI.com service uses.  

Is this the best possible solution currently?

https://www.microsoft.com/en-us/download/details.aspx?id=41653&751be11f-ede8-5a0c-058c-2ee190a24fa6=...

If so, I suppose we'll need to create a program that pulls this down weekly and modifies a firewall rule automatically.   

[rsmccall33]

Our PowerBI subscription lives in useast2, so I created a firewall rule to allow inbound traffic from all of the useast2 IP subnets to any local port.  I'm still unable to connect to Jira using the PowerBI connector.  I'll have to see what else could be blocking me. 

[v-yuezhe-msft]

@rsmccall33,

Yes, you would need to keep an eye on the updated Azure datacenter IP ranges and whitelist them in your firewall.

Regards,
Lydia

[rsmccall33]

Thank you for confirming Lydia.

Do all IP Ranges operate on port 443 alone?  If there are others, what are they?

[v-yuezhe-msft]

@rsmccall33,

Based on this article, *.powerbi.com operates on port 443, and other fully qualified domain names used by Power BI gateway operate on other ports such as 5671, 5672, 9350 thru 9354.

Regards,
Lydia