Edit

Amazon OpenSearch Service (Beta)

  • Article

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 Beta
Products Power BI (Semantic models)
Power BI (Dataflows)
Fabric (Dataflow Gen2)
Authentication Types Supported Basic

Prerequisites

Capabilities supported

  • Import
  • DirectQuery (Power BI semantic models)

Connect to OpenSearch Project

  1. Open Power BI Desktop.

  2. Select Home > Get Data > More > Other, select OpenSearch Project, and then select Connect.

  3. You'll get a warning for using a third-party service. Select Continue.

  4. Enter host and port values and select your preferred SSL option. Then select OK.

  5. Select an authentication option. Enter credentials if necessary, and then select Connect.

  6. Select the required table. Data preview will then be loaded.

  7. Select Load.

  8. Select the required columns for creating a graph.

Troubleshooting

If you get an error indicating the driver wasn't installed, install the OpenSearch SQL ODBC Driver.

If you get a connection error:

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