Using Elasticsearch for full text search

[Anonymous]

I'm building a product in PowerBI, and want to implement full text search across a set of documents stored in elasticsearch. I'm interested in using this connector to do this in PowerBI: link

It's unclear to me if this connector allows me to send search queries to elasticsearch, or if it just allows us to import the table into PowerBI. Can someone clarify this?

[mahoneypat]

Think video walks through using a REST API.

Power BI - Tales From The Front - REST APIs - YouTube

What type of searches are you doing with ElasticSearch?  Does your company already have a license/data there?  Or are you analyzing data already in Power BI?  If the latter, are you aware of the text analytics capability native in Power BI service now?

Regards,

Pat

[mahoneypat · Accepted solution]

That would not be straight forward, but it might be possible in two ways - 

1. If you have a REST API to send your search terms, you can do that through the query editor with http POST requests

2. You may be able to do it with R or Python, either through the query editor or dynamically through and R/Python visual (which would respond to slicers, etc.).

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Anonymous]

Hello,

I also need to get all the data from my ES request, and not onyl the 10.000 first rows, without paying an ODBC driver licence.
Can you tell me more about the REST API @mahoneypat please ?

BR Sam.