Forum Discussion

mep's avatar
mep
Frequent Visitor
3 years ago

How to retrieve data from an Amazon OpenSearch Service (Beta) connector in DirectQuery Mode

Documentation says Amazon OpenSearch Service (Beta) connector supports  DirectQuery (Power BI Datasets) source: https://learn.microsoft.com/en-us/power-query/connectors/amazon-opensearch-service ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi mep ,

 

Go to "Get data", choose the connector.

In the Data Connectivity mode, you can choose DirectQuery.

 

 

   

                                                                                                                                                         

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

mep's avatar
mep
Frequent Visitor
3 years ago

Thank you Stephen,

I can succesfully setup the connection under the DQ mode as you are showing. However, I'm encountering a limitation with the connector. Once the connection is established, I find myself restricted to retrieving only the top 1000 rows of data. Unfortunately, I don't have the option to access the remaining data or apply filters to control the selection of the top 1000 rows. This limitation significantly hinders my ability to make the most of this connector.