Forum Discussion

Recce's avatar
Recce
Regular Visitor
5 years ago
Solved

On-Premise Gateway data source account seems to require Local Admin on the Server to refresh

I have an on-premise data gateway connecting to an on-premise SSAS 2019. I've been able to get it to work, but only by adding the account used to connect to the SSAS (ie. the credentials setup in the...
  • Recce's avatar
    5 years ago

    Misunderstanding on my part. The acccount the SSAS service is running under needs to belong to Windows Authorization Access group in Active Directory, not the GatewayReader in my example above.

     

    Strangely this group assignment isn't required when the client is on the internal network / domain, but is required in the cross domain scenario of having the client being the PowerBI cloud service connecting to the on-premise gateway. There's proably something else at play here that I don't understand.