Microsoft Excel
Supported Versions
Microsoft Excel version 16.95 (25030928) for Mac introduces a change that causes Excel to crash when using the Arrow Flight SQL ODBC driver. The crash occurs immediately after authentication, before the query/source selection dialog appears. This issue only affects Excel 16.95 on macOS. Excel on Windows is not impacted. See Hiding the SQL Tables Listing for a fix.
Microsoft Excel in Microsoft 365
Prerequisites
- Ensure that you are using Dremio v22.0 or later.
- Ensure that your operating system is 64-bit Windows 10 or later.
- Download, install, and configure the Arrow Flight SQL ODBC driver.
- If you want to authenticate to Dremio by using a personal access token (PAT), rather than by using a password, generate a PAT. See Personal Access Tokens for the steps.
Connecting to Dremio
- In Excel, select Data from the menu bar.
- Click Get Data.
- Select From Other Sources > From ODBC.
- In the From ODBC dialog, select the data source name that you specified when you configured the Arrow Flight SQL ODBC driver.
- Specify the username to use for the connection to Dremio.
- Specify either a password or a personal access token to use with the username
- In the Navigator dialog, select a dataset.
- Click Load.
Hiding the SQL Tables Listing
You can prevent Excel from crashing by enabling the hideSQLTablesListing
flag to hide the list of available sources in the query/source selection dialog. This flag can be used for Mac computers with an Apple silicon or an Intel processor.
To set the configuration:
- Go to the System DSN tab of the ODBC Manager.
- Click Configure.
- Change the value of the
hideSQLTablesListing
keyword totrue
. - Click OK.
Using the Extended Flight SQL Buffer
Inactivity can sometimes lead to query timeouts. To avoid a query timeout, you can enable the ODBC driver to pull the query results without having to wait for Excel to process them. This flag can only be used for Mac computers with an Apple silicon processor.
To set the configuration:
- Go to the System DSN tab of the ODBC Manager.
- Click Configure.
- Click Add.
- For Keyword, enter
useExtendedFlightSQLBuffer
. - For Value, enter
true
. - Click OK.