# Returning more than 10000 records in Power BI
**URL:** https://discuss.elastic.co/t/returning-more-than-10000-records-in-power-bi/99371
**Category:** Elasticsearch
**Created:** [September 5, 2017, 5:49am UTC](https://discuss.elastic.co/t/returning-more-than-10000-records-in-power-bi/99371 "2017-09-05T05:49:23Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@adam.burgess](https://discuss.elastic.co/u/adam.burgess)
#### Post date: [September 5, 2017, 5:49am UTC](https://discuss.elastic.co/t/returning-more-than-10000-records-in-power-bi/99371/1 "2017-09-05T05:49:23Z")
Hi There,
I have a requirement to use Power BI to query ES to create a model with ES and other data sources. My problem is that my data I need to return is currently about 14000 rows and slowly growing. I'm looking for advice on how to get around this by not hard coding a size of documents to returned.
Regards,
Adam
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [September 5, 2017, 6:55am UTC](https://discuss.elastic.co/t/returning-more-than-10000-records-in-power-bi/99371/2 "2017-09-05T06:55:05Z")
You probably want to use the scroll feature: [https://www.elastic.co/guide/en/elasticsearch/reference/current/search-request-scroll.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-request-scroll.html)
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [October 3, 2017, 6:55am UTC](https://discuss.elastic.co/t/returning-more-than-10000-records-in-power-bi/99371/3 "2017-10-03T06:55:18Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.