Connect Power BI Service to SingleStoreDB via Power BI Gateway

To connect Power BI service to SingleStoreDB Cloud via Power BI gateway:

  1. Install The SingleStore ODBC Driver.

  2. Download and install the Power BI on-premises data gateway. For more information, see What is an on-premises data gateway.

  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.

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

    Manage_gateways_settings.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).

    • For Basic Authentication,

      • In the Server field, enter the hostname or IP address of the SingleStoreDB Cloud workspace.

      • Enter the username and password used to connect to SingleStore in the Username and Password field, respectively.

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

    Note

    SingleStoreDB Cloud users can only use Basic authentication.

The connection is now configured and ready to use. For more information, see Microsoft's Power BI documentation 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.