SingleStore DB

Connect Power BI Desktop to SingleStore

To connect Microsoft Power BI Desktop to SingleStore DB:

  1. In Power BI Desktop, select File > Options and Settings > Options.

  2. In the Options dialog, in the left pane, select Security.

  3. Under Data Extensions, select (Not recommended) Allow any extension to load without validation or warning, to allow PowerBI to use the SingleStore Direct Query Connector 1.0.

    16083b57884fb3.png
  4. In the Home ribbon, from the Get Data list, select More.

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

    16083b5789f4da.png
  6. In the SingleStore database dialog, in the Server box, enter the IP address or hostname of the SingleStore cluster. Under Data Connectivity mode, select the #data-connectivity-modes, and then select the OK button.

    16083b578a63be.png
  7. In the SingleStore Direct Query Connector 1.0 dialog, in the left pane, select the authentication type (Windows or Basic).

    1. For Windows authentication, set up a SingleStore server for Kerberos authentication. Then, in the SingleStore Direct Query Connector 1.0 dialog, select the Connect button.

      Note

      You need to run Power BI with the user account that maps to the SingleStore DB user.

      ss-db-windows.png
    2. For Basic authentication, enter the username and password used to connect to SingleStore, and select the Connect button.

      16083b578ad56b.png
  8. In the Navigator dialog, choose the tables to import, and select the Load button.

    16083b578b4dbc.png

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

Modify Credentials

To modify the credentials used to connect to SingleStore DB:

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

  2. In the Data source settings dialog, select SingleStore DirectQuery Connector 1.0, and then select Edit Permissions….