Forum Discussion
Using MS Access as a data source with On-Premises Data Gateway
I'm having a little bit of difficulty understanding this part:
Grant RWX (including modify) permissions for the user you configured for this datasource on the AppData\Local folder of the user that runs the gateway's service.
How did you determine what user runs the gateway service? And when it says user that configured the data source, is that the person that owns the semantic model or has access to that particular gateway connection or something else entirely.
Thanks,
Steve
Hi Steve,
user that runs the gateway's service = the service account that you see in services.msc on the gateway host running the service 'On-premises data gateway service'. By default, this account is called PBIEgwService, so the AppData folder is going to be [gateway host]\C$\Users\PBIEgwService\AppData
user you configured for this datasource - the user whose credentials are used for the gateway connection to authenticate. Careful, this isn't (necessarily) 'the user that configured the data source', it's the credentials used