wgrusznis opened a new issue, #4306:
URL: https://github.com/apache/arrow-adbc/issues/4306
### What happened?
Using ADBC driver in Power BI returns error for COLLATE UTF8_LCASE columns
hard to say exactly where is it coming from - PBI wraps drivers in
powerQuery layer, almost sure the driver itself is the csharp one
An error occurred in the ‘’ query. Expression.Error: Unable to understand
the type for column
Details:
c2
This is PowerQuery that I used for testing and replicating this bug.
= Value.NativeQuery(
Databricks.Catalogs(
"<DATABRICKS_HOST>",
"<SQL_WAREHOUSE_PATH>",
[
Catalog = "<CATALOG_NAME>",
Database = null,
QueryTags = null,
EnableAutomaticProxyDiscovery = "enabled",
Implementation = "2.0"
]
){[Name = "<CATALOG_NAME>", Kind = "Database"]}[Data],
"select#(lf)
collation('Test') as t1#(lf)
,collation('Test' COLLATE UTF8_LCASE) as t2#(lf)
,'Test' as c1#(lf)
,'Test' COLLATE UTF8_LCASE as c2",
null,
[EnableFolding = true]
)
### Stack Trace
_No response_
### How can we reproduce the bug?
PowerQuery Implementation = "2.0" switches to ADBC driver, leaving it as
null returns to ODBC mode (where UTF8_LCASE works correctly)
= Value.NativeQuery(
Databricks.Catalogs(
"<DATABRICKS_HOST>",
"<SQL_WAREHOUSE_PATH>",
[
Catalog = "<CATALOG_NAME>",
Database = null,
QueryTags = null,
EnableAutomaticProxyDiscovery = "enabled",
Implementation = "2.0"
]
){[Name = "<CATALOG_NAME>", Kind = "Database"]}[Data],
"select#(lf)
collation('Test') as t1#(lf)
,collation('Test' COLLATE UTF8_LCASE) as t2#(lf)
,'Test' as c1#(lf)
,'Test' COLLATE UTF8_LCASE as c2",
null,
[EnableFolding = true]
)
### Environment/Setup
windows, power bi Version: 2.153.1206.0 64-bit (April 2026) , databricks
via SQL warehouse (v 2026.10)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
