Failed Clickhouse ODBC - Connection for Power BI

Hello everyone,
I am intending to use my new M1 Macbook to do work in Power BI, however, after a successful installation of Parallels, I am unable to access some of the Clickhouse databases through an ODBC-connection and I am getting continuously an "193-error" and both on the 32-bit and 64-bit version of ODBC data sources.

I have read through similar posts on the forum, but I have still not fully understood if there does not exist any current workaround for this issue.
https://forum.parallels.com/threads/postgresql-odbc-driver-unicode-64-bit.356444/
https://forum.parallels.com/threads/mysql-connector-odbc-for-win-11-arm.356741/#post-908639

I have bought my Mac specifically for work, and this is a blocker for me, as I would have to continue using my older Windows device daily if this does not work..