Forum Discussion
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:
- Personal Gateways (PGW) are not listed under 'Manage Gateways' like Enterprise Gateways are.
- The only way to 'configure' PGWs is via the 'schedule refresh' screen for a dataset.
- My problem was caused because the required MySQL connector was not installed on the machine with the PGW.
- 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
- ankitpatiraCommunity 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.
- skasperResponsive 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.
- skasperResponsive Resident
Here is the solution to my problem:
- Personal Gateways (PGW) are not listed under 'Manage Gateways' like Enterprise Gateways are.
- The only way to 'configure' PGWs is via the 'schedule refresh' screen for a dataset.
- My problem was caused because the required MySQL connector was not installed on the machine with the PGW.
- 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.