Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
Solved! Go to Solution.
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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
165 | |
83 | |
68 | |
68 | |
59 |