Hello!
Is there a way to limit loading of rows? I am not talking about removing rows to load onto a sheet.
Long story short, I am doing a query from my email. It takes quite a long time to load years worth of emails before it proceeds to the next step and only want to load (lets say) 2 weeks worth. I am looking to optimize the duration of the query.
Thanks in advance!
Hi Kenneth,
You can turn off data load in background. File tab > Options & Settings > Options > Current Workbook Data Load: deselect 'allow data previews to download in the background'.
Let me know if that doesn't help.
Mynda
Hello Mynda,
Unfortunately this does not help, I actually turn almost all my queries off and use a macro to tell which query to refresh first especially since I need some of them to refresh in sequencial order.
When I look at the status as the query refreshes, it says it's downloading over 60k rows and climbing. I want to prevent that so that it doesn't take that long to load.
Thank you for the suggestion though!
Ken.
Hi Kenneth,
Perhaps I'm not understanding what you mean. Where are these 60k rows downloading to? A table in the Excel file, the Power Pivot data model or the query editor? If either of the first two, then the only option is to filter the data in Power Query and reduce the amount of data you're bringing into Excel.
I'm not sure what you mean by 'the next step'. Is this the next step in the query? Are your queries dependent on one another, or are you loading data to the workbook, which you then reference in another query? It will help to understand what these queries are doing.
Mynda
