Skip to main content

Microsoft Excel

You can use Microsoft Excel to query and transform data through Dremio Cloud.

Supported Versions​

You must use locally installed versions of Excel in Microsoft 365.

Supported Authentication Methods​

There are two methods of authenticating that you can choose from when you connect to Dremio Cloud from Apache Superset or Preset:

  • Use Microsoft Azure Active Directory as an enterprise identity provider
    To configure Microsoft Azure Active Directory, see Microsoft Azure Active Directory.
    note:You can use Microsoft authentication only if the admin for your Dremio Cloud organization has enabled it.
  • Use a personal access token (PAT) obtained from Dremio Cloud
    To create a PAT, follow the steps in the section Creating a Token.
  • When you connect to to Dremio Cloud from Excel on macOS, you use a personal access token obtained from Dremio Cloud, specifying it in the user DSN that uses the ODBC driver for Arrow Flight SQL. To create a PAT, follow the steps in the section Creating a Token.

Prerequisites​

Creating a Connection If You Are Running Excel on Windows​

  1. In Microsoft Excel, select Data > Get Data > From Other Sources > From ODBC.

  2. Select the name of the user DSN that you created when configuring the ODBC driver. Then, click OK.

  3. Specify your authentication credentials in the ODBC driver dialog:

    • If you want to authenticate by using a Microsoft account and password, and Microsoft Azure Active Directory is configured as an enterprise identity provider for Dremio Cloud, click Windows in the sidebar and then follow either of these steps:

      • If you want to use the Microsoft account that you are currently logged into, select the option Use my current credentials is selected.
      • If you want to use a different Microsoft account, select the option Use alternate credentials and specify the username and password.

    • If you want to authenticate by using the personal access token that you specified when configuring the user DSN, click Default or Custom in the sidebar.

  4. Click Connect.

Creating a Connection If You Are Running Excel on macOS​

  1. In Microsoft Excel, select Data > Get External Data > New Database Query > From Database.
  2. Select the name of the user DSN that you created when configuring the ODBC driver. Then, click OK.
  3. In the dialog that asks for your username and password, leave the fields blank and click OK. You already specified your personal access token when you configured the user DSN.
note:

If Excel displays this message, follow these steps:

Message

Alert [Apache Arrow][Flight SQL] (200) Failed to authenticate with user and password: IOError: Flight returned unauthenticated error, with message: . Detail: Unauthenticated.



**Steps** 1. Close Microsoft Excel. 1. Open the file `/Library/ODBC/odbc.ini`. 1. In the DSN entry for the ODBC driver for Arrow Flight SQL, remove these two lines: ``` UID = [USERNAME] PWD = [PASSWORD] ``` 1. Save and close the file. 1. Launch Microsoft Excel and try again to connect to Dremio Cloud.