Prerequisites

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

  1. Download and install the latest version of Power BI Desktop listed in the certification matrix.

    Note

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

  2. Download and install the SingleStore Power BI Bundle. This bundle installs the SingleStore ODBC driver, sets up the Power BI connector, and adds the SingleStore Direct Query Connector option to the Get Data list in Power BI. See Data Connectivity Modes for more information.

    Note

    If you are using an older version, upgrade the connector to the latest version. See Upgrade the SingleStore Power BI Connector for more information.

Upgrade the SingleStore Power BI Connector

Note

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

To upgrade the SingleStore Power BI connector to the latest version:

  1. Uninstall the previous version of the connector. Additionally, delete the connector files from the machine. By default, the SingleStore connector files are located in the %USERPROFILE%\Documents\Power BI Desktop\Custom Connectors folder.

  2. Download the SingleStore Power BI Bundle 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 Power BI Bundle on this machine.

  3. Install the Power BI Bundle on the machines. It installs the latest versions of the SingleStore ODBC driver and copies the latest version of the connector in the default Custom Connectors folder.

    Note

    For gateway machines, if the gateway is using a folder that is different from the default folder (%USERPROFILE%\Documents\Power BI Desktop\Custom Connectors), copy the .mez file from the default folder to the target folder, and then restart the gateway. Make sure that the gateway can access the new file.

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.