Forum Discussion
Solved
Adding sql database source to a gateway using a service account
I have several power bi datasets that I have added to a gateway. When I added the datasources to the gateway I used my active directory credentials. I've set these datasets to auto refresh which wor...
Hi smmoore34 ,
It depends on what type of credentials the source requires.
A service account is just a fake person so, if a real person (e.g. you) use Windows auth, then the Service account will use that too, same for Basic/OAuth.
Obviously you need to ensure that your service account has permissions to access the source before any of these will work.
Pete
Hi smmoore34
If you are using SQL Server on local drive, it seems that you should choose Windows Authentication.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!