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.
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?
Community ChampionYou 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.I just learned our vendor is running Aurora (MySQL-compatible) on AWS' RDS services. Would I be able to connect to this service? If so, how would I go about doing this?