Connect with Power BI

You can create interactive dashboards and analysis reports from your SingleStore cluster's data in Power BI.

Prerequisites

Before connecting Power BI to SingleStore, perform the following tasks.

  1. Download and install the latest version of Power BI Desktop.

    Note

    The SingleStore Direct Query connector only supports 64-bit versions of Power BI.

  2. Download and install the latest version of The SingleStore ODBC Driver.

If you are using an older version of Power BI and the connector, see Upgrade the SingleStore Direct Query Connector.

Upgrade the SingleStore Direct Query Connector

Note

You may need to update the Power BI reports after upgrading the connector.

The SingleStore Direct Query connector is included in the latest version of Power BI. To upgrade the connector to the latest version:

  1. If you are using the SingleStore Power BI Bundle, uninstall it. Ensure that the connector files are deleted from the machine. By default, the connector files are located in the %USERPROFILE%\Documents\Power BI Desktop\Custom Connectors folder.

  2. Download and install the latest version of The SingleStore ODBC Driver on the machines with Power BI Desktop and gateway.

    Note

    If the same machine is running Power BI Desktop and acting as the gateway, download and install the SingleStore ODBC driver on this machine.

  3. Update Power BI Desktop to version 2.106.883.0 or later.

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.

In this section

Last modified: February 6, 2023

Was this article helpful?