Skip to main content

Power BI Desktop

This topic describes how to connect Power BI Desktop to your CelerData cluster.

Prerequisites

Before proceeding, make sure the following requirements are met:

  • Install Power BI Desktop.
  • Install and configure MySQL Connector ODBC 8.0.23.
    • For Windows, click here to download the package.
    • For macOS, click here to download the package.
note

If you get an installation error because you have installed a newer version of MySQL Connector ODBC, or if you get an error that says "There weren't enough elements in the enumeration to complete the operation" when connecting to your CelerData cluster, you must uninstall and remove the connector currently installed on your device and re-install the required version.

Connect Power BI Desktop to CelerData

Step 1. Allow third-party connectors

Configure Power BI Desktop to allow third-party connectors. After you submit the configuration, restart Power BI Desktop. For detailed instructions on how to allow third-party connectors, see Microsoft Official Documentation.

Step 2. Install StarRocks Power BI Connector

  1. Download the StarRocks Power BI Connector file StarRocks.mez.
  2. Store the file in the directory [Documents]\Power BI Desktop\Custom Connectors. Create the directory if it does not exist.

Step 3. Connect through the Connector

  1. Launch Power BI Desktop.

  2. Click Get data from another source.

    img

  3. In the Get Data section, search and select StarRocks.

    img

    tip

    If you cannot find StarRocks in the list, make sure you have done exactly as instructed in Step 1 and 2. Be sure to restart Power BI Desktop after you allow third-party connectors.

  4. Configure credentials for the Connector in the StarRocks data source section. Set the StarRocks Data Source to {StarRocks_FE_IP}:{query_port}. Select DirectQuery as Data Connectivity mode.

    img

    tip

    You can run SHOW FRONTENDS in your CelerData cluster to check the IP and Query Port of the FE nodes.

  5. Select the tables you want to include in your report, and click Load.

    img

  6. In the dashboard that appears, click the model tab in the top left corner, and define the relationships (Joins) between tables.

    img

    note

    If you get an error that says "There weren't enough elements in the enumeration to complete the operation" when connecting to your CelerData cluster, you must uninstall and remove the connector currently installed on your device and re-install the required version.

  7. Navigate back to the report table and run your report.

Usage notes

You can observe how the queries have been issued to your CelerData cluster by navigating to http://{StarRocks_FE_IP}:{http_port}/query in your browser.

  • Run SHOW FRONTENDS in your CelerData cluster to check the IP and HTTP Port of the FE nodes.

  • If you cannot see the query history, run the following statement to enable your CelerData cluster to collect query details:

    ADMIN SET FRONTEND CONFIG ("enable_collect_query_detail_info" = "true");