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 ...
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.
I should have mentioned that this is importing the data, due to the complexity of some of the measures (which aren't supported via DirectQuery).