Dears,
With the new release 3.3.2 I have a crash each time I refresh my tables on PowerBI.
Please find the stack trace in attachmentlogDremio.log.zip (6,5 Ko)powerBiError.log.zip (2,6 Ko)
@jscreve Can you share a profile with us (https://www.dremio.com/tutorials/share-query-profile-dremio/) - it would contain more information about the query and why its failing.
Here you areprofile.zip (14,6 Ko)
Hello @jscreve, it looks like you have a mixed type for one of the columns of mongod.smarthome.users and the ODBC driver is not equipped to handle this.
When you visit the table in the Dremio UI, does one of the columns have a type icon that looks like A#? If so you can try to build a virtual dataset where this field is cast to the desired type.
Thanks for your help.
The problem was due to the date recognized now as a complex type.
I solved the issue with a CAST to varchar and a CAST to date
Regards
Le jeu. 12 sept. 2019 à 00:48, Ben via Dremio dremio@discoursemail.com a écrit :