Hi @dkh2345,
How did you get data from AWS Opensearch to Power BI? Data connector or export data from AWS and use the Power BI push datasets API to create a dataset.
If you mean the first one, if you want load more records, you can choose the 'Load more" option in the navigator dialog to load additional rows in increments of 10k rows.
For the second one, current Power BI REST API limit maximum of 10,000 rows per single POST rows request. You may need to split these records to 10k interval and sent in different requests.
Power BI REST APIs push datasets limitations - Power BI | Microsoft Learn
Regards,
Xioaxin Sheng
