Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Note
This connector is owned and provided by OpenSearch Project.
Summary
| Property | Value |
|---|---|
| Connector |  OpenSearch Project |
| Products | Power BI (semantic models) Power Query Online |
| Release state | Preview |
| Category | Other |
| Authentication kinds | AWS_SIGV4 BASIC NONE |
| Data source kind | OpenSearchProject |
| Function Reference Documentation | OpenSearchProject.Contents |
| Support link | Contact the connector owner. |
Prerequisites
Supported capabilities
- Import
- DirectQuery (Power BI semantic models)
Parameters
Entry point: OpenSearchProject.Contents
Required parameter count: 3
| Parameter | Display name | Required | Type | Description | Allowed values | Sample values | Nullable | Declared allowed values |
|---|---|---|---|---|---|---|---|---|
| Server | Server | Yes | text | The hostname of the OpenSearch server. | "localhost" | false | ||
| Port | Port | Yes | number | Port which OpenSearch server listens on. | 9200 | false | ||
| UseSSL | Use SSL | Yes | logical | Use SSL | true; false | false | [true, false] |
Connect from Power Query Desktop
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.