Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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.
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:
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.
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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.