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 above setup with PBI?

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.

4 Replies

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    5 years ago

    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.

    • 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.