Forum Discussion
Azure SQL DB and OnPrem data refresh question
If your source changes from an On-Prem SQL Database to Azure SQL DB, then there is no need for a On-Premise Gateway.
Once you make the data source changes, you should be able to edit your Data Source settings and change it from using the On-Premise Gateway to just the cloud?
It will then transfer the data directly from the Azure SQL DB to the Power BI Service. And as long as they are in the same tenant there should be no egress charges
GilbertQ, thanks for the response.
I do know that users can setup the credentials for the refresh out in the service. My concern is that when their passowords expire the refreshes will fail. I want to use an IT controlled userid/password combination with a never expiring password and I don't want to give those credentials out to my business users. So.. the only solution for that would be for any business user that wants to publish a dataset accessing teh Azure SQL DB to contact IT to setup their refresh schedule. That is not ideal.
Defining a connection on the gateway does allow me to have an IT managed solution that does not expose the IT controlled userid/password because there I can define the connection (I would be the only one knowing the credentials) on the Gateway and I could add each business user as a person that can publish and use that connection. That may cause the data to traverse cloud to on prem to cloud. I'll be tracing this scenario Wed with my network guys.