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 Amazon.
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.