Forum Discussion

trev1972a's avatar
trev1972a
Icon for Advocate I rankAdvocate I
2 years ago
Solved

Accidental writeback to database risk "admin has granted access, credentials are not required"?

Hey all   I have been using power bi for a little while, now and although i have read that power bi cant write back to an sql server by accident i do use an account with read only database access t...
Data Protection
  • aj1973's avatar
    aj1973
    2 years ago

    You will, just be patient with Power BI as it is a huge SaaS tool with a lots of infos. Good luck.

    Please mark this thread as accepted for the rest of the community

     

     

trev1972a's avatar
trev1972a
Icon for Advocate I rankAdvocate I
2 years ago

It has been a long time since i set up the data gateway but it isnt running as a domain user, it is running as 

NT SERVICE\PBIEgwService  if that helps?

 

I know i probably seem paranoid but really want minimal priveliges possible.

  • trev1972a's avatar
    trev1972a
    Icon for Advocate I rankAdvocate I
    2 years ago

    Hi aj1973

     

    Everything is updating fine on the refresh schedule? and the gateway shows as online?

    I have maybe a dozen reports updating twice daily and they all refresh ok?

     

    I have read the link, but it doesnt suggest there is any issue with using the default service account on the gateway?

     

    I am tempted not to mess as it is currently working, based on the earlier assurance that i cant accidentally damage our database through power BI

     

    Thanks again.