search

opensearch-project / sql-odbc

OpenSearchODBC is a read-only ODBC driver for Windows and Mac for connecting to OpenSearch SQL support.
Apache License 2.0
7 stars 17 forks source link

[BUG] Using Power BI with aliased indices #63

Open jeremypoulter opened 1 year ago

jeremypoulter commented 1 year ago

What is the bug? We have been trying to connect Power BI to our OpenSearch domains but are having troubles with using aliased indexes.

This looks to be down to SHOW tables LIKE %; reporting an instance of the alias for every index that is using it. This in itself is handled by Power BI, but then when you try to connect to the aliased index/table Power BI reports an error 'Expression.Error: The key matched more than one row in the table.'

Can you offer any guidance?

How can one reproduce the bug? Steps to reproduce the behavior:

  1. Make a new OpenSearch data source: image

  2. Select one of the instances of the aliased index image

  3. See error image

What is the expected behavior? Ideally the aliased index should only show up once in the list of indices, but even if it does selecting it should continue and not show an error.

What is your host/environment?

Manibharathi77 commented 1 year ago

+1, facing same issue in open search connector as well.. Work around for this are all quite ineffective.