Forum Discussion

Sokon's avatar
Sokon
Advocate V
8 years ago

Using MS Access as a data source with On-Premises Data Gateway

23.11.2018: Another update: The order of the installations is important. 22.11.2018: I updated this article. Let me know if it works for you!   When publishing a report that uses an on-Premises MS...
Tips and Tricks
sjm334's avatar
sjm334
Frequent Visitor
1 year ago

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

JoshT's avatar
JoshT
Advocate III
1 year ago

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

  • sjm334's avatar
    sjm334
    Frequent Visitor
    1 year ago

    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?

    • JoshT's avatar
      JoshT
      Advocate III
      1 year ago

      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!