Amazon OpenSearch Service (Beta)
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
- Microsoft Power BI Desktop
- OpenSearch
- OpenSearch SQL ODBC driver
Capabilities supported
- Import
- DirectQuery (Power BI semantic models)
Connect to OpenSearch Project
Open Power BI Desktop.
Select Home > Get Data > More > Other, select OpenSearch Project, and then select Connect.
You'll get a warning for using a third-party service. Select Continue.
Enter host and port values and select your preferred SSL option. Then select OK.
Select an authentication option. Enter credentials if necessary, and then select Connect.
Select the required table. Data preview will then be loaded.
Select Load.
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:
- Check if the host and port values are correct.
- Check if the authentication credentials are correct.
- Check if the server is running.