Skip to content

Latest commit

 

History

History
75 lines (46 loc) · 3.05 KB

AmazonOpenSearchService.md

File metadata and controls

75 lines (46 loc) · 3.05 KB
Raw

Connecting Amazon OpenSearch Service to Microsoft Power BI Desktop

[!Note]

The following connector article is provided by Amazon, the owner of this connector and a member of the Microsoft Power Query Connector Certification Program. If you have questions regarding the content of this article or have changes you would like to see made to this article, visit the OpenSearch website and use the support channels there.

Summary

Item Description
Release State General Availability
Products Power BI Desktop
Authentication Types Supported Basic

Prerequisites

Capabilities supported

  • Import
  • DirectQuery

Connect to Amazon OpenSearch Service

  1. Open Power BI Desktop.

  2. Click on Home > Get Data > More > Other. Select Amazon OpenSearch Service. Click on Connect.

  1. You will get a warning for using a third-party service. Click on Continue.

  1. Enter host and port values and select your preferred SSL and Certificate validation options. Click on OK.

  1. Select authentication option. Enter credentials if required and click on Connect.

  1. Select required table. Data preview will be loaded.

  1. Click on Load.

  2. Select required columns for creating a graph.

Troubleshooting

  • If you get the following error,

  1. Check if host and port values are correct.
  2. Check if auth credentials are correct.
  3. Check if server is running.

Limitations and Known issues

There are known limitations and issues that are tracked by OpenSearch including the items listed below.

Issue Description
Visualizations with First or Last options selected are not yet supported First and Last options generate an sql query that uses MAX and MIN for strings which is not yet supported in OpenSearch
Visualizations with aggregate functions selected are not yet supported Specifically Minimum, Maximum, Standard deviation, Variance, or Median options are not yet supported.
Top N filtering limitations OpenSearch has limitations on subquery which does not yet support the Top N filtering functionality.