Using Service Account instead of Individual Account to refresh Data from SQL Server

[Anonymous]

Hi, 

• I have a report using import option from a sql server. 
• In Power BI Desktop i have used my login to connect to dev environment and imported data. 
• Publish the dev version to Power BI service Dev Workspace.  I am marked are owner of the dataset when i publish.

All refresh schedule is done under my individual account , which I consider is risk. 

1. Is there any best practice on how to set up service account to do data refreshes rather than individual  ?
2. If service acount is possible, how this can be set up, as currently I login as me using AAD and how service account can be set up just to refresh the dataset?
3. Also currently i have to type in manually the connection string , is there any best practice for this to be secure? 

I don think it is not linked to Azure Keyvault so that is not an option. 

thanks

[Anonymous]

Hi @Anonymous ,

You can refer the content in the following links to change to service account:

Change the on-premises data gateway service account

Service account credentials for data set refresh

Best Regards

Rena 

[Anonymous]

Hi Thanks for your reply.

It is not on-prem , it is Azure SQL, for that reason I dont require any gateways and no VMs in the picture. 

How do we apply service account for sources that is already in Azure?

thanks 

[amitchandak]

@Anonymous , if you are using on-premise SQL server than you need to setup gateway

https://radacad.com/the-power-bi-gateway-all-you-need-to-know

In the case of Azure SQL, you can change the credentials in power Bi service and make it work. 

Refer:https://radacad.com/power-bi-get-data-from-azure-sql-database

https://www.youtube.com/watch?v=yAKRXF1CQf0

[aj1973]

Hi @Anonymous 

You will need anothor pro license account to be used for the service account that you want to create.