---
title: "Install the Power BI Connector"
slug: "install-the-power-bi-connector"
updated: 2026-03-03T15:33:13Z
published: 2026-03-03T15:33:13Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documentation.lakesidesoftware.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Install the Power BI Connector

The Power BI Connector is a SysTrack Kit, named **SysTrack PowerBI**. You must import this Kit before you can complete the steps in the following sections.

> [!WARNING]
> **IMPORTANT**: You can download the Kit on the [DEX and Kit Downloads page](/documentation/docs/dex-and-kit-downloads-2).

## Run the Automation for the Connector

The Kit named **SysTrack PowerBI** includes an automation named **InstallLakesidePowerBICertificate**. You can find and configure the automation in SysTrack Configure.

![](https://cdn.document360.io/87d11426-6b1f-4b19-b593-b71e55a81af3/Images/Documentation/PowerBiAutomationPg02.png)

Before you can run the automation, follow these steps:

1. At Configure > Automations and Collection Extensions > Automations (tab), [edit the Automation](/documentation/docs/edit-automations). Select the operating system you want in the **Operating System** field.
2. At Configure > Automations and Collection Extensions > [Action Governance](/documentation/docs/action-governance) (tab), select the Automation. Then Approve and Enable it.

The Automation must be Approved and Enabled before you can use it. To check whether it has been approved, select the Automations tab, and look at the **Approved?** and **Enabled?** fields (under **Action Details**).
3. In the **Description** field, add a Description (which is optional) to remind everyone of this automation's purpose.

When you are ready to run the automation for the Connector, you can run the automation with one of these methods:

- Run the automation in [Resolve](/documentation/docs/actions-tools#run-an-automation).
- Run the automation via a [Schedule](/documentation/docs/schedule-automations).

> [!TIP]
> **TIP**: The SysTrack agent reads the configuration changes, and then the automation will appear in [Resolve](/documentation/docs/actions-tools#run-an-automation). If you need to expedite this process, you can [force a Read Configuration](/documentation/docs/operations-command-dashboard) to the endpoint and wait a few minutes for the automation to appear.

When you run the **InstallLakesidePowerBICertificate** automation, it installs the Lakeside Signed Certificate.

After you run the automation, you are ready to install the Custom Connector PQX in [the following section](/documentation/docs/install-the-power-bi-connector#install-the-custom-connector-pqx). Then you can [use the connector in Power BI](/documentation/docs/use-the-power-bi-connector-with-api-keys).

If you prefer to manually install the Lakeside Signed Certificate, you can [follow these steps](/documentation/docs/install-the-power-bi-connector#manually-install-the-lakeside-signed-certificate).

## Install the Custom Connector PQX

In your documents folder, you should see the path **Power BI Desktop > Custom Connectors**.

1. If the folder does not exist, create it.

![pqx file location](https://cdn.document360.io/87d11426-6b1f-4b19-b593-b71e55a81af3/Images/Documentation/pqx_location.png)
2. Copy the **LakesidePowerBIConnector.pqx** into the **Custom Connectors** folder.

> [!NOTE]
> **NOTE**: If you use OneDrive, make sure you copy the LakesidePowerBIConnector.pqx into the **Custom Connectors** folder that Power BI accesses. The folder path could be:
> 
> **C:\Users\<YourUsername>\Documents\Power BI Desktop\Custom Connectors**
> 
> Or if the **Documents** folder is part of your OneDrive path, the path could be:
> 
> **C:\Users\<YourUsername>\OneDrive\Documents\Power BI Desktop\Custom Connectors**
> 
> Ensure that your **Custom Connectors** folder is synced and available offline.

## Manually Install the Lakeside Signed Certificate

If you prefer to install the Certificate manually, you can use the following steps.

> [!WARNING]
> **IMPORTANT**: The best practice is to run the **InstallLakesidePowerBICertificate** automation, which completes the following steps for you.

1. Install Power BI Desktop based on your processor type.
2. To add the certificate thumbprint to the registry, go to **HKEY_LOCAL_MACHINE\Software\Policies\Microsoft\Power BI Desktop**.
3. If the folder does not exist, right-click the Microsoft folder and select **New** > **Key**.
4. Name the folder **Power BI Desktop**.

![](https://cdn.document360.io/87d11426-6b1f-4b19-b593-b71e55a81af3/Images/Documentation/Install_the_Lakeside_Power.png)
5. If the Power BI Desktop folder does exist, select **New** > **Multi-String Value**.

![](https://cdn.document360.io/87d11426-6b1f-4b19-b593-b71e55a81af3/Images/Documentation/Install_the_Lakeside_Power_1.png)
6. Select **REG_MULTI_SZ**, and name it **TrustedCertificateThumbprints**.

![](https://cdn.document360.io/87d11426-6b1f-4b19-b593-b71e55a81af3/Images/Documentation/Install_the_Lakeside_Power_2.png)
7. Enter the thumbprint: **E820602155DC57E2981197005D46D78E7E4503DF**
8. You might get the following warning:

![](https://cdn.document360.io/87d11426-6b1f-4b19-b593-b71e55a81af3/Images/Documentation/Install_the_Lakeside_Power_3.png)
9. If you have entered the thumbprint correctly (with no blank line after it), click **OK**.