Re: [I] Power BI - using UTF8_LCASE column returns error Unable to understand the type for column [arrow-adbc]
CurtHagenlocher commented on issue #4306: URL: https://github.com/apache/arrow-adbc/issues/4306#issuecomment-4489492048 Moved to https://github.com/adbc-drivers/databricks/issues/459 -- 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]
Re: [I] Power BI - using UTF8_LCASE column returns error Unable to understand the type for column [arrow-adbc]
wgrusznis commented on issue #4306: URL: https://github.com/apache/arrow-adbc/issues/4306#issuecomment-4408627195 awesome, thank you @eric-wang-1990 for looking into it. -- 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]
Re: [I] Power BI - using UTF8_LCASE column returns error Unable to understand the type for column [arrow-adbc]
eric-wang-1990 commented on issue #4306: URL: https://github.com/apache/arrow-adbc/issues/4306#issuecomment-4407875163 @wgrusznis Actually I just reproed with latest driver, it seems this only occurs for NativeQuery, if you are dealing with a table the error does not exist. Yeah I think we need to patch the connector in this case since for NativeQuery pbiConnector use different way to get metadata, I will put a fix -- 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]
Re: [I] Power BI - using UTF8_LCASE column returns error Unable to understand the type for column [arrow-adbc]
eric-wang-1990 commented on issue #4306: URL: https://github.com/apache/arrow-adbc/issues/4306#issuecomment-4407793170 @davidhcoe Can you check if that commit lands on Mar 3rd made into Apr release? https://github.com/adbc-drivers/databricks/pull/285 I guess it did not. @wgrusznis Can you try build the ADBC driver and copy all the content under \databricks\csharp\artifacts\AdbcDrivers.Databricks\Debug\net472 to C:\Program Files\Microsoft Power BI Desktop\bin\Adbc Drivers\Databricks? Note you need to copy the net472 folder, and Debug/Release based on which you build. -- 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]
Re: [I] Power BI - using UTF8_LCASE column returns error Unable to understand the type for column [arrow-adbc]
wgrusznis commented on issue #4306: URL: https://github.com/apache/arrow-adbc/issues/4306#issuecomment-4407278956 I'm using latest as for today power bi desktop - Version: 2.153.1206.0 64-bit (April 2026) it ships with the csharp adbc driver for testing i build https://github.com/adbc-drivers/databricks/ csharp version and replaced it in powerbi folder if I understand correctly eric's change STRING COLLATE [anything...] should still be exposed as STRING https://github.com/adbc-drivers/databricks/pull/285/commits but for UTF8_LCASE i still saw -> STRING COLLATE UTF8_LCASE, but don't get me wrong, it might be that what I tried to override with my cshar build was not in correct placa/might be re-writen by powerbi if checskum were not what expected etc. but in my opinion actually the powerbi connector wrapper is missing the line to just treat STRING [add anything here] as STRING. right now it sees STRING COLLATE UTF8_LCASE and says "I have no idea what to do with that" (query. Expression.Error: Unable to understand the type for column) -- 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]
Re: [I] Power BI - using UTF8_LCASE column returns error Unable to understand the type for column [arrow-adbc]
davidhcoe commented on issue #4306: URL: https://github.com/apache/arrow-adbc/issues/4306#issuecomment-4407039877 To be clear, are you using the driver from https://github.com/adbc-drivers/databricks/? What version of Power BI do you have? cc @eric-wang-1990 -- 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]
Re: [I] Power BI - using UTF8_LCASE column returns error Unable to understand the type for column [arrow-adbc]
wgrusznis commented on issue #4306: URL: https://github.com/apache/arrow-adbc/issues/4306#issuecomment-4406245949 alright I made some digging in Power BI connector (M query/PowerQuery wrapper) first finding: although I replaced csharp ADBC driver with my build still what it outputs for UTF8_LCASE is ' STRING COLLATE UTF8_LCASE' -> but here might be catch, PowerBI likes to revert some of the files when it noticed they were altered. but then I looked in the PBI databricks connector. in DatabricksAdbc.pqm there is already code that handles type mappings originalType -> adjustedType i added one line in there else if Text.StartsWith(connectorType, "STRING") then "STRING" build new version and this actually solves it. So I think actually the Power Bi wrapper needs to be patched, and the ADBC driver works as expected. -- 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]
Re: [I] Power BI - using UTF8_LCASE column returns error Unable to understand the type for column [arrow-adbc]
wgrusznis commented on issue #4306: URL: https://github.com/apache/arrow-adbc/issues/4306#issuecomment-4400676835 Hi David, thank you for prompt answer. It looks very much related with my issue. although @hb0313 error on fabric is much clearer in powerbi desktop is less explicit https://github.com/user-attachments/assets/853adbfc-b380-49b5-b332-07bc61c6f337"; /> I build the csharp driver and replaced it in my local power bi installation and the error is still there. I'll try to extract the metadata queries power bi produces to see if there is anything unusual there. -- 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]
Re: [I] Power BI - using UTF8_LCASE column returns error Unable to understand the type for column [arrow-adbc]
wgrusznis commented on issue #4306: URL: https://github.com/apache/arrow-adbc/issues/4306#issuecomment-4400618751 Hi David, thank you for prompt answer, looks very much related indeed! although [hb0313](https://github.com/hb0313) had much clearer error on Fabric service, I'm on powerbi desktop https://github.com/user-attachments/assets/4affa672-846c-4705-adf4-4f1008ac5d1e"; /> I build the csharp driver and replaced it in the PowerBI installation and I still get the same error. I'll try to dig bit deeper in the metadata queries it produces to see if there is something interesting in there. -- 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]
Re: [I] Power BI - using UTF8_LCASE column returns error Unable to understand the type for column [arrow-adbc]
lidavidm commented on issue #4306: URL: https://github.com/apache/arrow-adbc/issues/4306#issuecomment-4397541375 I believe this was answered here, does this match your problem? https://github.com/apache/arrow-adbc/discussions/4245 -- 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]
