Forum Discussion
Solved
Can you turn off querying hive in Excel Power Query anytime you make a change?
We have a hive schema set up with a number of tables, some of which have over a million records. We are trying to access the tables within Excel and are using the Presto Driver by going to Get Data -...
If you query the server for few millions of records and on next step filtered them down to few hundreds, Power Query in background combine these steps and returns from the server only few hundreds. That's query folding. If it doesn't work or if you break it with another step, filtering will be done on the client site and that could take years to perform.
Hi - JKPieterse in our case we are also using the data in Tableau and will not be able to limit the number of records in the database. I am actually very surprised that the application would send requests to the database for any movement like moving a column to another location.
As far as I know PowerQuery only does that during development of the query, I *think* it is trying to optimize the query along the way. But I'm no PQ expert by any means 🙂
- Thank you for taking time to respond and confirming what Sergei posted as well above!