Forum Discussion
Using Service Account instead of Individual Account to refresh Data from SQL Server
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.
- Is there any best practice on how to set up service account to do data refreshes rather than individual ?
- 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?
- 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
4 Replies
- aj1973
Community Champion
Hi Anonymous
You will need anothor pro license account to be used for the service account that you want to create.
- amitchandak
Super User
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
Hi Anonymous ,
You can refer the content in the following links to change to service account:
Change the on-premises data gateway service account
Best Regards
Rena
