cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

Puplic IP of Power BI Service during Dataset Refersh using new Snowflake Connector

Hello

In the file Azure IP Ranges and Service Tags – Public Cloud https://www.microsoft.com/en-us/download/details.aspx?id=56519 we can only find a section for Power Query Online. It looks like a Dataset refresh using the new Snowflake connector uses different IPs. Is there any possibility to identify all public IPs sed by a Dataset refresh for Region north/west Europe?
THX
Klaus

4 REPLIES 4
Highlighted
Community Support
Community Support

Hi @klabir

 

Searching by "AzureCloud.northeurope", Line Number: 34087 - 35011,you will find all the IPs for Region north Europe.

Annotation 2020-03-26 110054.png

Searching by "AzureCloud.westeurope", Line Number: 35883 - 36065,you will find all the IPs for Region west Europe.

 

Annotation 2020-03-26 110828.png

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
 
Highlighted

Hi Kelly

 

thank you very much, i saw that. but we do not want to whitelist so many IPs. It should be only a few, like Power Query online , here are only 2 Ips to whitelist. any idea how to narrow down?

THX

Klaus

Highlighted

Hi @klabir ,

 

Here is a similar thread you can refer to :

https://community.powerbi.com/t5/Service/What-is-the-right-method-to-allow-Power-BI-service-IPs-thro...

 

My suggestion is to use gateway,which can limit outbound ports,and only needs 443 port,then the data source only needs to provide the whitelist of the gateway machine.

Here is the reference.

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-communication

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

 

 

Highlighted

Hello Kelly

Thank you very much again for your answer. Unfortunately we want to exactly avoid the gateway, because it is slow. The new Snowflake Connector in Power BI does not need a Gateway anymore and this is what we want to leverage. But we can not allow such a big Number of IPs to be whitelisted.

THX

Klaus

 

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors