Can Azure PowerBI connect to an Elastic Query?

[Anonymous]

The title says it all really. I have an elastic pool of 20 databases and I wish to run PowerBI across the pool. I've been able to query across all the databases with Elastic Queries, but I can't see how to connect that to PowerBI.

I think it should be possible if I stick a WebAPI over the elastic queries and connect that to PowerBI. But is that the best way?

[v-chuncz-msft]

@Anonymous,

There isn't a specific connector for Elasticsearch right now. Based on my research, you could use the "From Web" source with the Elasticsearch REST API and write Power Query Formula Language in the Advanced Editor.

https://blog.sixeyed.com/querying-elasticsearch-with-powerbi/