Forum Discussion
PowerBI Services - New Gateway Connection - IP Address
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.
Community ChampionIt 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?
- edhans
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.I assume the same holds true for the Personal Gateway? Is there another alternative to keep PBI data sync'd?
- edhans
Same.
The only other way for Power BI to get data is if it is in the cloud. So your vendor could sync their data with Azure SQL, then you could connect to that without a gateway. But no way to do that directly to on prem data without a gateway.