# Connect Power BI Service to SingleStore via Power BI Gateway

To connect Power BI service to SingleStore via Power BI gateway:

1. Install [The SingleStore ODBC Driver](https://docs.singlestore.com/db/v9.1/developer-resources/connect-with-application-development-tools/connect-with-odbc/the-singlestore-odbc-driver.md).

2. Download and install the [Power BI on-premises data gateway](https://powerbi.microsoft.com/en-us/gateway/). For more information, see [What is an on-premises data gateway](https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem).

3. In the gateway installer, sign in to Microsoft Office 365 with your organization email address to register your gateway.

4. Select **Register a new gateway on this computer** > **Next**.

5. In the **On-premises data gateway** dialog, enter a name for the gateway (for example, **SingleStore**). Create and confirm a recovery key. Select **Configure**. The on-premises data gateway is ready to use. If you face connection issues, see [Troubleshoot gateways](https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot).

6. In Power BI, select **Workspaces** > **Create a workspace**. In the created workspace, select **Settings** > **Manage gateways**.

   ![](https://images.contentstack.io/v3/assets/bltac01ee6daa3a1e14/bltdc264d0864b91281/6a2c433e724dc3c15b81c693/Manage_gateways_settings-J0fPDw.png)

7. In the **On-premises data gateways** tab, open **Settings** for the gateway.

8. In the **Settings** pane, select the following checkboxes:

   * **Distribute requests across all active gateways in this cluster.**
   * **Allow user's cloud data sources to refresh through this gateway cluster.**
   * **Allow user's custom data connectors to refresh through this gateway cluster.**

9. In the **Data Sources** tab, select **New**.

10. In the **New data source** dialog:

    * Select the **Gateway cluster name** from the list.
    * Enter a name for the data source in the **Data source name** field.
    * From the **Data source type** list, select **SingleStore database**.
    * Enter the database name in the **Database** field.

11. Select the authentication method (**Basic** or **Windows**).

    * For **Basic** Authentication,

      * In the **Server** field, enter the hostname or IP address of the SingleStore cluster.
      * Enter the username and password used to connect to SingleStore in the **Username** and **Password** field, respectively.
    * For **Windows** authentication, [set up a SingleStore server for Kerberos authentication](https://docs.singlestore.com/db/v9.1/security/authentication/kerberos-authentication.md).

      * In the **Server** field, enter the hostname or IP address of the SingleStore cluster.

    Select **Skip Test Connection** to resolve any connection errors that may arise due to a failed connection test, and then select **Add**.

The connection is now configured and ready to use. For more information, see [Microsoft's Power BI documentation](https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-custom-connectors) to enable and use the custom connector capability in the on-premises data gateway.

## License

SINGLESTORE, INC. ("SINGLESTORE") AGREES TO GRANT YOU AND YOUR COMPANY ACCESS TO THIS OPEN SOURCE SOFTWARE CONNECTOR AND PROVIDE SUPPORT & MAINTENANCE OR OTHER SERVICES ONLY IF (A) YOU AND YOUR COMPANY REPRESENT AND WARRANT THAT YOU, ON BEHALF OF YOUR COMPANY, HAVE THE AUTHORITY TO LEGALLY BIND YOUR COMPANY AND (B) YOU, ON BEHALF OF YOUR COMPANY ACCEPT AND AGREE TO BE BOUND BY ALL OF THE OPEN SOURCE TERMS AND CONDITIONS APPLICABLE TO THIS OPEN SOURCE CONNECTOR AS SET FORTH BELOW (THIS “AGREEMENT”), WHICH SHALL BE DEFINITIVELY EVIDENCED BY ANY ONE OF THE FOLLOWING MEANS: YOU, ON BEHALF OF YOUR COMPANY, CLICKING THE “DOWNLOAD, “ACCEPTANCE” OR “CONTINUE” BUTTON, AS APPLICABLE OR COMPANY’S INSTALLATION, ACCESS OR USE OF THE OPEN SOURCE CONNECTOR AND SHALL BE EFFECTIVE ON THE EARLIER OF THE DATE ON WHICH THE DOWNLOAD, ACCESS, COPY OR INSTALL OF THE CONNECTOR OR USE ANY SERVICES (INCLUDING ANY UPDATES OR UPGRADES) PROVIDED BY SINGLESTORE.

APPLICABLE OPEN SOURCE LICENSE: GNU LESSER GENERAL PUBLIC LICENSE Version 2.1

IF YOU OR YOUR COMPANY DO NOT AGREE TO THESE TERMS AND CONDITIONS, DO NOT CHECK THE ACCEPTANCE BOX, AND DO NOT DOWNLOAD, ACCESS, COPY, INSTALL OR USE THE SOFTWARE OR THE SERVICES.

***

Modified at: July 8, 2022

Source: [/db/v9.1/query-data/connect-with-analytics-and-bi-tools/connect-with-power-bi/connect-power-bi-service-to-singlestore-via-power-bi-gateway/](https://docs.singlestore.com/db/v9.1/query-data/connect-with-analytics-and-bi-tools/connect-with-power-bi/connect-power-bi-service-to-singlestore-via-power-bi-gateway/)

(An index of the documentation is available at /llms.txt)