Log in into the Power BI Service, click on the Download menu and choose the option Data Gateway. Now you go to the downloadpage of the Data Gateway.
It is preferable to install the Data Gateway on each a computer running 24×7, so you can refresh the reports at any time. The Data Gateway can be installed in 2 ways: ‘on-premises data gateway’ and ‘on-premises data gateway (personal mode)’. Both options are possible, but we prefer to use the ‘on-premises data gateway’ so different users can make use of the same gateway.
The setup of the Data Gateway is explained by Microsoft on their website: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem
After the setup is done, it is important to check if the Data Gateway has access to the folder C:\Users\<Username>\Documents\Microsoft Power BI Desktop\Custom Connectors where the connector is installed.
Follow the steps below to check this:
- Run the ‘On-premises data gateway’ and go to the section Service Settings.
- Check the Gateway service account, default this is ‘NT SERVICE\PBIEgwService’. This serviceaccount needs access rights to the folder C:\Users\<Username>\Documents\Microsoft Power BI Desktop\Custom Connectors
- In the Windows Explorer go to the folder C:\Users\<Username>\Documents\Microsoft Power BI Desktop, rightclick the folder Custom Connectors and choose Properties.
- Go to the tab Security and check if the user PBIEgwService exists in the list. If not, click on Edit.
- Click on Add.
- Enter the name NT SERVICE\PBIEgwService (att.: a space between NT and SERVICE) and click on OK.
- Ensure the user PBIEgwService has at least checked ‘Read & execute’, ‘List folder content’ and ‘Read’.
- Click on OK twice.
- Go back to the ‘On-premises data gateway’ and go to the section Connectors.
- Check if the ConnectorExactOnline is shown in the list.