# Elasticsearch and Power bi connection through ODBC driver **URL:** \ **Category:** Elasticsearch\ **Tags:** docker\ **Created:** [February 13, 2023, 3:42pm UTC](https://discuss.elastic.co/t/elasticsearch-and-power-bi-connection-through-odbc-driver/325405 "2023-02-13T15:42:24Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Vitaliy.N](https://avatars.discourse-cdn.com/v4/letter/v/94ad74/32.png) [@Vitaliy.N](https://discuss.elastic.co/u/Vitaliy.N)\ **Post date:** [February 13, 2023, 3:42pm UTC](https://discuss.elastic.co/t/elasticsearch-and-power-bi-connection-through-odbc-driver/325405/1 "2023-02-13T15:42:24Z")
Hello Everyone, I am trying to connect Elasticsearch (running in docker container) with desktop power bi and having some issues. When testing connection using ODBC driver I am getting this error "libcurl: failed to perform." "libcurl: failure code 35, message: SSL connect error." Is this an issue because I don't have platinum subscription or is it something wrong with my settings? Thank's for help in advance! ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [February 13, 2023, 4:34pm UTC](https://discuss.elastic.co/t/elasticsearch-and-power-bi-connection-through-odbc-driver/325405/2 "2023-02-13T16:34:04Z")
I don't know if this is the cause of the error message but indeed you need a trial or a platinum license at least. ---
**Author:** ![Vitaliy.N](https://avatars.discourse-cdn.com/v4/letter/v/94ad74/32.png) [@Vitaliy.N](https://discuss.elastic.co/u/Vitaliy.N)\ **Post date:** [February 13, 2023, 4:54pm UTC](https://discuss.elastic.co/t/elasticsearch-and-power-bi-connection-through-odbc-driver/325405/3 "2023-02-13T16:54:13Z")
Thank you for your reply. Just to double check, ODBC driver is the only way it is possible to connect Elasticsearch with power bi correct? I'm doing a bit of a research of behalf of someone else and want to cover all possible bases. Thank you! ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [February 13, 2023, 5:08pm UTC](https://discuss.elastic.co/t/elasticsearch-and-power-bi-connection-through-odbc-driver/325405/4 "2023-02-13T17:08:47Z")
If PowerBI can support REST API then you can use that. But I don't know PowerBI 🙂 ---
**Author:** ![Vitaliy.N](https://avatars.discourse-cdn.com/v4/letter/v/94ad74/32.png) [@Vitaliy.N](https://discuss.elastic.co/u/Vitaliy.N)\ **Post date:** [February 13, 2023, 6:06pm UTC](https://discuss.elastic.co/t/elasticsearch-and-power-bi-connection-through-odbc-driver/325405/5 "2023-02-13T18:06:57Z")
> [@Vitaliy.N](#): > > ODBC driver Just to clarify, Elasticsearch has REST API that we can call to retrieve data? Pardon for repeating the question but I am not very well versed in this topic. thank you in advance. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [February 13, 2023, 6:32pm UTC](https://discuss.elastic.co/t/elasticsearch-and-power-bi-connection-through-odbc-driver/325405/6 "2023-02-13T18:32:50Z")
Yes. Elasticsearch rest api. ---
**Author:** ![bogdan.pintea](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bogdan.pintea/32/45740_2.png) [@bogdan.pintea](https://discuss.elastic.co/u/bogdan.pintea)\ **Post date:** [February 14, 2023, 8:31am UTC](https://discuss.elastic.co/t/elasticsearch-and-power-bi-connection-through-odbc-driver/325405/7 "2023-02-14T08:31:58Z")
> [@Vitaliy.N](#): > > "libcurl: failure code 35, message: SSL connect error." By default, the driver attempts to connect securely. If your Elasticsearch cluster isn't configured to use certificates, you'll need to change the connection settings in ODBC to disable the encryption. > [@Vitaliy.N](#): > > ODBC driver is the only way it is possible to connect Elasticsearch with power bi correct? You can use indeed the [REST API](https://www.elastic.co/guide/en/elasticsearch/reference/current/search.html), but it'll require good Power BI and it's internal language knowledge. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [March 14, 2023, 8:32am UTC](https://discuss.elastic.co/t/elasticsearch-and-power-bi-connection-through-odbc-driver/325405/8 "2023-03-14T08:32:35Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.