Install and Configure the Gateway
The following instructions describe how to prepare the Power BI Gateway for use with the CData Power BI Connector for Act-On in the Act-On Enterprise Edition.
- Download the Standard Mode installer from the Power BI Gateway download page.
- Run the installer and click Install.
- Provide an email address in the Email address to use with this gateway field and click Sign in. Sign in with the Microsoft account selection form.
- Choose register a new gateway on this computer and click Next.
- Create a name and recovery key for the gateway, then click Configure.
The gateway then starts and its desktop application, "On-premises data gateway", opens. - Open the Connectors tab and set Load custom data connectors from folder: to the location of the custom connectors. By default, these are installed to C:\Users\<installing user>\Documents\Power BI Desktop\Custom Connectors.
- Note: Your custom connector folder must be present on your local machine. You can't use a folder that mirrors a cloud storage service folder, such as a OneDrive folder.
- Click Apply > Apply & Restart. A table displays the custom connectors that have been discovered.
- Ensure that the service account that the Power BI Gateway runs under, 'NT Service\PBIEgwService', has access to the Custom Connectors folder you set in the previous step:
- Right-click the Custom Connectors folder and select Properties.
- On the Security tab, click Edit.
- Click Add....
- Set the Enter the object names to select field to "NT Service\PBIEgwService" and click OK > Apply > OK > OK.
- To register the changes with the Gateway, in the On-premises data gateway desktop UI, navigate to Service Settings > Restart the Gateway and click Restart now.