Solved: Missing Data from AWS OpenSearch to Power BI

dkh2345 · ‎07-26-2023

Hello Everyone!
I'm trying to extract data from AWS OpenSearch to Power BI, but I got only 10k rows out of millions of rows. Anyone has any idea how to solve this?
Thanks

Anonymous · ‎07-31-2023

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

View solution in original post

Anonymous · ‎07-31-2023

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