Configure Power BI

Configuring the Data Gateway for Power BI requires placing all custom connectors in the designated folder. The process includes verifying connector installation and confirming the gateway's online accessibility. This setup ensures that the Data Gateway is effectively configured, enabling seamless integration between Power BI and various data sources.

The Data Gateway requires all custom connectors to be placed into a fixed folder.

Best Practice: The typical folder path is: C:\Windows\ServiceProfiles\PBIEgwService\Documents\Power BI Desktop\Custom Connectors.

Configure

  1. On your machine (EX: your PC), navigate to C:\Users\%username%\Documents\Power BI Desktop\Custom Connectors.

    • If any folders on this path are missing, create those folders now (EX: Custom Connectors).

  2. Paste InveniasPowerBI.mez into the Custom Connectors folder.

  3. In the On-premises data gateway interface, go to the Connectors tab in and check the specified connector path.

    1. The typical folder path is: C:\Windows\ServiceProfiles\PBIEgwService\Documents\Power BI Desktop\Custom Connectors.

  4. Click the Service Settings tab and click the Restart now link.

  5. After the restart, return to the Connectors tab to check that the connector is now installed.

Verify

  1. Go to https://app.powerbi.com and sign in using the same Microsoft domain that the gateway was registered to.
  2. Click the cog icon and select on the Manage connections and gateways ⟶.
  3. Click the On-premises data gateways tab and verify the gateway you created exists.
  4. Click the Check Status icon and wait for powerbi.com to verify that the gateway is accessible and online.

Observe that the gateway is indeed online.

Next Steps

Now that you have the Data Gateway configured for Power BI, you can enable it to refresh your data. For details, see Data Gateway Refresh Enablement.