Forum Discussion
PowerBI Services - New Gateway Connection - IP Address
I am setting up a new connection point between PowerBI in the cloud and a 3rd party data source to allow for nightly refreshes. Gateway services are running on an internal server. The 3rd party needs to register my IP address to grant access to their site. How do I go about doing this? It is my understanding my Azure tenant's IP address continously changes.
You have to have a gateway on your vendor's site. It isn't off prem, it is on prem, just not your prem.
The gateway on their machine will need to log into your Power BI tenant.
7 Replies
It doesn't change, but there are a lot. You can get the full list here - Download Azure IP Ranges and Service Tags – Public Cloud from Official Microsoft Download Center
You'd need to add all of those to the white listing section in your third party's service.
After further reading, I think my approach may be incorrect. The scenario is the following. I created a PowerBI report using PBI desktop. My source data is coming from one of my vendor's SQL databases (off-premise). I'm using the credentials and connection information they provided me to make the connection to their system. From there I was able to pull in tables, create and publish my reports using the PowerBI Desktop. Now that we wish to go live with these reports companywide; I now need to publish these reports to the PBI cloud service. I need to maintain the connection point between these reports and my vendor's MySQL database. Should the PBI Gateway be used in this scenario, or is there a different configuration I should use?
You have to have a gateway on your vendor's site. It isn't off prem, it is on prem, just not your prem.
The gateway on their machine will need to log into your Power BI tenant.