Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
dkh2345
New Member

Missing Data from AWS OpenSearch to Power BI

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 

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.