# Connect Power BI Desktop to SingleStore

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](https://learn.microsoft.com/en-us/power-query/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](https://powerbi.microsoft.com/en-us/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](https://docs.singlestore.com/db/v9.1/security/authentication/kerberos-authentication.md). 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.

     ![](https://images.contentstack.io/v3/assets/bltac01ee6daa3a1e14/blt8379c13c32c4f7cc/6a2c438bdc089942972f2412/16083b578b4dbc-1QeSSl.png)
   * **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](https://learn.microsoft.com/en-us/power-query/native-database-query#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**.

***

Modified at: March 16, 2026

Source: [/db/v9.1/query-data/connect-with-analytics-and-bi-tools/connect-with-power-bi/connect-power-bi-desktop-to-singlestore/](https://docs.singlestore.com/db/v9.1/query-data/connect-with-analytics-and-bi-tools/connect-with-power-bi/connect-power-bi-desktop-to-singlestore/)

(An index of the documentation is available at /llms.txt)