Im trying to connect elasticsearch to power-bi using the Open Distro ODBC driver, but the problem is that the (64bit version) crashes when i click on “Test”.
Ive tried both the elasticsearch version that Open Distro provides and the one that is available on the elastichstack website.
These are the settings i used for the configuration of the elasticsearch version provided by Open Distro.
I also tried installing the 32bit version of the driver. While using the same settings this driver didnt crash, tho it did gave the following error:
Connection error: [Open Distro For Elasticsearch][SQL ODBC Driver][SQL Plugin] Connection error: failed to establish connection to DB.
Also i can connect perfectly fine when i use the following shell command:
curl -XGET https://localhost:9200 -u admin:admin --insecure
Thanks in advance for the help!