Forum Discussion

anigam-proofpt's avatar
anigam-proofpt
Regular Visitor
4 years ago
Solved

What IP adderss does Power Bi uses to pull the data from Azure SQL database

Hi Team,

I am trying to figure out the IP address that Power BI uses to pull the data from the Azure SQL database. This was the question raised by our Azure SQL admin to whitelist the IP address that Power uses so that the data is transferred between the systems without any error.

I am not aware of any such technicality related to the connector. Seeking your help.

Regards,

Ayush 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.