Forum Discussion
Community ChampionChange Data Gateway Settings, and best practice for SQL Server?
Firstly, you can directly go to settings->Managa gateways in Power BI Service, find the SQL data source within the configured gateway, then change account as shown in the following screenshot.
Secondly, you can use domain account or SQL account in this scenario, as Power BI uses this account to connect to your SQL instance, it will not access your network resources.
Thirdly, do you configure gateway in several machines? If so, you just need to change account as I describe in step 1.
Regards,
Lydia
Firstly, you can directly go to settings->Managa gateways in Power BI Service, find the SQL data source within the configured gateway, then change account as shown in the following screenshot.
Secondly, you can use domain account or SQL account in this scenario, as Power BI uses this account to connect to your SQL instance, it will not access your network resources.
Thirdly, do you configure gateway in several machines? If so, you just need to change account as I describe in step 1.
Regards,
Lydia
Community ChampionThank you Lydia. Super useful info. Since I set it up on the PC, I was expecting to modify it on the PC. My mistake. :-)
On the network account, my concern wasn't the gateway posing a security risk but the existence of another domain user account being another attack surface.
I am going to try to modify this week. Also want to get the new gateway MS just released installed. Finally can mashup on-prem data with cloud (Sharepoint) data!