topic Re: replacing Elastic Logstash in Service

replacing Elastic Logstash

aherabit — Thu, 05 Aug 2021 19:14:33 GMT

Hi Folks.

We have a Logstash service with which we monitor, a folder, and push CSV files onto kibana/search.

The csv files, source folders, are on a Linux box.

Help: How can we replace the above setup with PBI?

Re: replacing Elastic Logstash

v-henryk-mstf — Mon, 09 Aug 2021 02:01:34 GMT

Hi aherabit ,

You can use the Elasticsearch ODBC driver to access Elasticsearch data from Microsoft Power BI Desktop.

Microsoft Power BI Desktop | Elasticsearch Guide [7.14] | Elastic

or enter base URL for the Search API in Web entry of Power BI Desktop. For more details, please check the following articles:

elasticsearchtutorial.com

Search API | Elasticsearch Guide [7.14] | Elastic

If the problem is still not resolved, please provide detailed error information and related screenshoot. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: replacing Elastic Logstash

aherabit — Tue, 24 Aug 2021 18:30:37 GMT

Thanks, Henry.

I don't have ODBC for Elasticsearch as the article stating. Any idea?

Also, the available ODBC driver is available on Windows but my Elasticsearch is running on Ubuntu.

Re: replacing Elastic Logstash

v-henryk-mstf — Wed, 25 Aug 2021 06:45:56 GMT

Hi aherabit ,

To establish a connection between Elasticsearch and Power BI, you need to install and configure the ODBC driver. Follow these steps to configure your DSN:

1.Go to your administrative tools and select your ODBC driver.
2.In the panel, select “System DSN” and click “Add..”.

3.Click on “Elasticsearch Driver” and “Finish”
.....

Then you can connect Elasticsearch to Power BI.

For more details, you can read related document:

Connect Elasticsearch to Power BI: An Easy Guide (hevodata.com)

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: replacing Elastic Logstash

aherabit — Wed, 25 Aug 2021 17:52:08 GMT

The current drivers, from Elastic, is not comptible... (requirs upgrades)

Any idea: how to add the connection through 'Web' option?
The connection is reaching but need to pass specific index info.