Returning more than 10000 records in Power BI


(Adam Burgess) #1

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


(David Pilato) #2

You probably want to use the scroll feature: https://www.elastic.co/guide/en/elasticsearch/reference/current/search-request-scroll.html


(system) #3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.