Forum Discussion

RhysLFS's avatar
RhysLFS
New Member
9 years ago
Solved

Mass IP Whitelisting for Azure Datacenter

Hi there,   Setting up an On-Prem Power BI Gateway and having issues with the proxy service this server sits under.   Looking to open up the IP addresses for the Azure Datacenter and have been kn...
Need Help
  • RhysLFS's avatar
    RhysLFS
    9 years ago

    Hi All,

     

    Found a solution to my problem.

     

    Downloading the newest version of the Power BI Gateway (or at least something from Februrary 2017 onwards) and setting the ServiceBusSystemConnectivityModeString to Https will force the Gateway to use Fully Qualified Domain Names (FQDN) instead of the IP addresses. These FQDN's are a part of the initial whitelist of proxies found in the on prem how to guide provided by Microsoft.

     

    This also has the advantage of being future proof as the chaging IP addresses will still point to the same FQDNs.

     

    Thanks Microsoft for providing this functionality.

     

    Cheers.

mmeyers's avatar
mmeyers
Frequent Visitor
5 years ago

why create/maintain a gateway when powerbi service has the ability to connect to amazon redshift directly?

andyskinner's avatar
andyskinner
Regular Visitor
5 years ago

Exactly my point too.  Another cloud BI tool I work with (Qliksense) can supply 2 static IP addresses for whitelisting.