Forum Discussion

aherabit's avatar
aherabit
Helper I
5 years ago
Solved

replacing Elastic Logstash

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 abo...
Need Help
Tips and Tricks
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    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.

aherabit's avatar
aherabit
Helper I
4 years ago

Thanks, Henry.

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

 

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

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

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.

  • aherabit's avatar
    aherabit
    Helper I
    4 years ago

    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.