SingleStore

Note

This connector is owned and provided by SingleStore.

Summary

Property Value
Connector SingleStore Direct Query Connector icon SingleStore Direct Query Connector
Products Power BI (semantic models)
Power Query Online
Release state General availability
Category Other
Authentication kinds Basic
Windows
Data source kind SingleStoreODBC
Function Reference Documentation SingleStoreODBC.Contents
SingleStoreODBC.DataSource
SingleStoreODBC.Database
SingleStoreODBC.Query
Support link Support

Supported capabilities

  • Import
  • DirectQuery (Power BI semantic models)
  • Advanced options
    • Native SQL statement

Note

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

Parameters

Entry point: SingleStoreODBC.Contents

Required parameter count: 2

The SingleStore Connector is a high-performance connector that lets you DirectQuery and import data from your SingleStore instance.

Parameter Display name Required Type Description Sample values Nullable
ServerAddr Server Yes text Provide your server address "127.0.0.1:3306" false
Database Database Yes text "mydatabase" false
options No nullable record true

Connect from Power Query Desktop

To connect Microsoft Power BI Desktop to SingleStore DB or Managed Service:

  1. In the Home ribbon, from the Get Data list, select More.

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

    Screenshot of the SingleStore connector selection in the Get Data dialog.

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

    • 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.

    Screenshot of the server, database, and data connectivity mode fields.

  4. In the SingleStore Direct Query Connector dialog box, in the left pane, select the authentication type (Windows or Basic).

    Note

    SingleStoreDB Cloud users can only use Basic authentication.

    • For Windows authentication, set up a SingleStore server for Kerberos authentication. Then 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, the database user must be administrator. You might need to create the database user.

      Screenshot of the Windows authentication selection.

    • For Basic authentication, enter the username and password used to connect to SingleStore, and then select the Connect button.

      Screenshot of the Basic authentication selection.

  5. After you authenticate, for Import or DirectQuery mode, in the Navigator dialog box, choose the tables you want and select the Load button.

    Screenshot of table selection and the Load button in the Navigator dialog.

You can now use Power BI to explore SingleStore data.

Additional 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 SingleStore Direct Query Connector, and then select Edit Permissions.

Limitations and considerations

Limitations of native database queries

  • To run a native database query by using the connector, you must have read-only access to the SingleStore databases.
  • DDL queries aren't supported.
  • If you specify the SQL query outside the connector dialog (the connection configuration step), Power BI might prompt you to approve the query for your credentials.

For more information, see Limitations and issues.

  • Last updated on