Forum Discussion

skasper's avatar
skasper
Responsive Resident
9 years ago
Solved

Personal Gateway not listed under 'Manage Gateways'

Situation:

Enterprise Gateway (EGW) installed on Server1 and actively being used by PowerBI.

 

In order to schedule refresh for on-premise data sources, I installed a Personal Gateway (PGW) on Server2. Setup runs through and the PGW is shown, when I go to 'Schedule Refresh' for one of my data sets:

 

However, clicking on 'Manage Gateways' I only find the EGW there:

Both Gateways run as a service on the respective servers and both use the same Windows Account.

 

Any idea, what I am missing here? Thank you.

  • Here is the solution to my problem:

    1. Personal Gateways (PGW) are not listed under 'Manage Gateways' like Enterprise Gateways are.
    2. The only way to 'configure' PGWs is via the 'schedule refresh' screen for a dataset.
    3. My problem was caused because the required MySQL connector was not installed on the machine with the PGW.
    4. Once this was installed and the PGW restarted, everything works fine.

    In the end it was a typical case of PeBCaK - Problem Exists between Chair and Keyboard.

3 Replies

  • ankitpatira's avatar
    ankitpatira
    Community Champion

    skasper You won't see gateway under Manage Gateways option if you're not the Administrator of the gateway ie person who has setup that gateway has to add you as an administrator of the gateway. If you are the person who installed person gateway then ensure that account you've used during installation of personal gateway is same as your account you are usign to login to power bi service.

    • skasper's avatar
      skasper
      Responsive Resident

      Thank you for the input.

      I am indeed the administrator for both gateways and installed both of them with the same account I am using for logging into PowerBI service.

  • skasper's avatar
    skasper
    Responsive Resident

    Here is the solution to my problem:

    1. Personal Gateways (PGW) are not listed under 'Manage Gateways' like Enterprise Gateways are.
    2. The only way to 'configure' PGWs is via the 'schedule refresh' screen for a dataset.
    3. My problem was caused because the required MySQL connector was not installed on the machine with the PGW.
    4. Once this was installed and the PGW restarted, everything works fine.

    In the end it was a typical case of PeBCaK - Problem Exists between Chair and Keyboard.