'Is there a way to connect Elasticsearch 5.6.4 to Power BI

my company is running an old version of Elasticsearh (v.5.6.4). Im not overly familiar with the Elastic Stack suite but I have been asked to start pulling data from it to Power Bi for analysis (PBI).

I have seen articles that allow for connection to Elasticsearch using an ODBC driver but I'm not sure if this applies to older versions.

Does anyone know if its possible to connect PBI to Elasticsearch v.5.6.4?

Alternatively, my company has Kibana, so perhaps there is a way to dynamically extract data from that without doing manual extracts?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source