Elasticsearch SQL URL on AWS

[GRob]

In my AWS Elasticsearch Kibana console I can use the following POST and Get commands to run a sql query...

POST /_opendistro/_sql
{
    "query": "SELECT ProjectCode,DateRun,DatabaseName FROM index1*"
}

or 

GET /_opendistro/_sql
{
    "query": """SELECT ProjectCode,DateRun,DatabaseName FROM index1*"""
}

Both return data as expected.
How can i now use either of them as a datasource in Power Bi?

What URL would i use as a datasource?

[v-lili6-msft]

hi  @GRob 

You mayr refer this post:

https://community.powerbi.com/t5/Desktop/Using-Elasticsearch-for-full-text-search/m-p/1145572

https://www.elastic.co/guide/en/elasticsearch/reference/master/sql-client-apps-powerbi.html

Regards,

Lin