Edit

Share via


Amazon OpenSearch Service (Beta)

Note

This connector is owned and provided by Amazon.

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.