Importing data into Excel from Databricks over ODBC OAuth / Simba Spark Driver

Michael_Galli
Databricks Partner

Hi all,
I am refering to this article
Connect to Azure Databricks from Microsoft Excel - Azure Databricks | Microsoft Learn

I use the latest SimbaSparkODBC-2.8.2.1013-Windows-64bit driver and configured in like in that documentation.
In Databricks I use a Serverless Warehouse (Current, v 2024.25)
I use Windows 11, Excel version 2403

Now when filtering data in Excel - Power query on that warehouse, in the Databricks query history I get the following error:

[UNBOUND_SQL_PARAMETER] Found the unbound parameter: _753. Please, fix `args` and provide a mapping of the parameter to either a SQL literal or collection constructor functions such as `map()`, `array()`, `struct()`. SQLSTATE: 42P02; line 36 pos 18

The query looks like this -> note the "?"

select
  `COLUMN1`,
from
  `catalog`.`schema`.`table`
where
  `PERIOD` = ?  and `PERIOD` is not null

Any idea on how to fix this?