Posted On: Jul 16, 2021

Amazon Elasticsearch Service now supports integrating with Microsoft Power BI, a business analytics service that delivers insights to enable fast, informed decisions. Powered by the Open Distro for Elasticsearch ODBC Driver you can now integrate your Microsoft Power BI environment with you Amazon Elasticsearch Service domains using the Open Distro for Elasticsearch SQL Engine.

The Open Distro for Elasticsearch SQL Engine uses Structured Query Language (SQL) to manifest search results in a tabular format. One of the key features of this engine is the Open Database Connectivity (ODBC) driver which enables you to integrate various business intelligence (BI) and analytics applications with Elasticsearch. You can now connect Amazon Elasticsearch Service with Microsoft PowerBI to create sophisticated and intelligent data visualizations on top of the search results obtained from Amazon ES by leveraging the Amazon ES- PowerBI Integration, to provide deep data insights.

Amazon ES- PowerBI integration is powered by Open Distro for Elasticsearch, an Apache 2.0-licensed distribution of Elasticsearch. Amazon ES- PowerBI is supported on all Amazon Elasticsearch Service domains running Elasticsearch 7.9 or greater. To learn more about Open Distro for Elasticsearch and Amazon ES- PowerBI integration, visit the project website and documentation.

Amazon ES-PowerBI integration for Amazon Elasticsearch Service are available across 24 regions globally: US East (N. Virginia, Ohio), US West (Oregon, N. California), GovCloud (US-Gov-East, US-Gov-West), Canada (Central), South America (Sao Paulo), EU (Ireland, London, Frankfurt, Paris, Stockholm, Milan), Asia Pacific (Singapore, Sydney, Tokyo, Seoul, Mumbai, Hong Kong), Middle East (Bahrain), China (Beijing) region, operated by Sinnet, China (Ningxia) region, operated by NWCD, and Africa (Cape Town). Please refer to the Region Table for more information about Amazon Elasticsearch Service availability.