Forum Discussion
Azure SQL Database Authentication
I believe that I've looked at all the posts on this but I can't find my answer. Sorry if it's already covered.
What is the best authentication method for accessing an Azure SQL database from the Power BI service? Our current approach is to set up a service account which can access the database. We then want to use that as the credentials for the dataset. The idea is that the service account updates the data each night and then we publish that data via an app.
However, when I try to log in with the service account it is always defaulting back to my own Office 365 account. I have discovered that I can log in to the Power BI service with the service account but I'm not sure if that is the correct method.
What route are people using for this?
Thank you in advance for your help.
9 Replies
Hi Anonymous,
As far as I know, we only need an account that has enough permission. What're your concerns?
Best Regards,
Dale
We want this report to update every night - it doesn't need any intervention once that is in place. I'm a contractor so we can use my credentials but once I leave it won't work, which seems not ideal (and the same can be said of anyone that uses their credentials).
Typically we would access SQL Server data using a service account or an AD group (or combination of both), but I can't see how that model applies here.
I was playing around yesterday and did discover that I can log in to Power BI with the service account itself, which could be a solution.
