Forum Discussion
smmoore34
2 years agoAdvocate II
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...
- 2 years ago
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
BA_Pete
2 years agoSuper User
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