Sign inTry Free

Connect Power BI Desktop to SingleStore

On this page

In addition to navigation-based data ingestion, Power BI also supports native database queries for the SingleStore connector which enables you to build reports using native SQL queries. To ingest data using a native SQL query, enter the query in the Native query box while configuring the connection.

Refer to Import data from a database using native database query for related information.

Note

Existing reports created using the SingleStoreODBC.Query connector function call continue to be supported. SingleStore recommends using native database queries for new reports.

To create a report in Power BI Desktop:

  1. In the Home ribbon, select Get Data > More.

  2. In the Get Data dialog, select SingleStore Direct Query Connector.

  3. In the connection configuration dialog, enter or select the following:

    • Server: Enter the IP address or the hostname of the SingleStore cluster.

    • Database: Enter the name of the SingleStore database to connect with.

    • Data Connectivity mode: Select Import or DirectQuery.

    • (Optional) To ingest data using a native database query, enter the SQL query in the Native query box.

  4. Select OK.

  5. In the connector dialog, in the left pane, select the authentication type (Windows or Basic).

    • For Windows authentication, set up a SingleStore server for Kerberos authentication. Then, in the connector dialog, select the Connect button.

      Note

      You need to run Power BI with the user account that maps to the SingleStore user. Therefore, if the Windows user is 'administrator'@domain, then the database user must be 'administrator'. You may need to create the database user.

    • For Basic authentication, enter the username and password of the SingleStore database user with which to connect to to SingleStore, and select Connect.

  6. After authentication, perform one of the following:

    • For navigation-based data import: Select the tables to import in the Navigator dialog.

    • For native database query: Verify the results in the preview.

  7. Select Load. Alternatively, you can select Transform Data to apply transformations before loading the data.

You can now use Power BI Desktop to explore your data.

To update the existing reports, select the Refresh button on the Home ribbon.

Limitations of Native Database Queries

  • To create a custom SQL report using the connector, the user must only have read-only access to the SingleStore databases.

  • DDL queries are not supported.

  • If the SQL query is specified outside the connector dialog (the connection configuration step), Power BI may prompt you to approve the query for your credentials.

Refer to Limitations and issues for more information.

Modify Credentials

To modify the credentials used to connect to SingleStore.:

  1. In the File ribbon, select Options and settings > Data source settings.

  2. In the Data source settings dialog, select the connector, and then select Edit Permissions.

Last modified: March 16, 2026

Was this article helpful?

On this page

Was this article helpful?

Verification instructions

Note: You must install cosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.

  1. (Optional) Run the following command to view the associated signature files.

    curl undefined

  2. Download the signature file from the SingleStore release server.

    • Option 1: Click the Download Signature button next to the SingleStore file.

    • Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.

    • Option 3: Run the following command to download the signature file.

      curl -O undefined

  3. After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

    echo -n undefined |
        cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \
          --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \
          --bundle undefined \
          --new-bundle-format -
    Verified OK

Try Out This Notebook to See What’s Possible in SingleStore

Get access to other groundbreaking datasets and engage with our community for expert advice.

Sign UpLog In