Forum Discussion
Using MS Access as a data source with On-Premises Data Gateway
Thank you so much for the extra information. This makes sense and I thought this was the case. I was able to confirm that in service.msc it shows the gateway as running with Log On As NT_SERVICE\PBIEgwService.
However, when I navigate to this path: [gateway host]\C$\Users\ I don't even see user PBIEgwService let alone am able to access it. Am I missing another step in my configuration or did was there something wrong with my installation?
If you're using the path exactly as I have typed it, it may not work because of policy restrictions at your organisation on accessing the hard drive externally (i.e. the C$ syntax). The alternative would be to log onto the box directly as an administrator, then go to C:\Users\.
FYI as an added bonus if you're a gateway admin and you haven't been to this folder before, navigate to C:\Users\PBIEgwService\AppData\Local\Microsoft\On-premises data gateway\Report and you get a bunch of reports on the queries that are passing through it!