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.
The title says it all really. I have an elastic pool of 20 databases and I wish to run PowerBI across the pool. I've been able to query across all the databases with Elastic Queries, but I can't see how to connect that to PowerBI.
I think it should be possible if I stick a WebAPI over the elastic queries and connect that to PowerBI. But is that the best way?
@Anonymous,
There isn't a specific connector for Elasticsearch right now. Based on my research, you could use the "From Web" source with the Elasticsearch REST API and write Power Query Formula Language in the Advanced Editor.
https://blog.sixeyed.com/querying-elasticsearch-with-powerbi/
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.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |