Forum Discussion
Solved
Turning a large query into a static data table
I have a large query with several million rows that i'm looking to store as a static data table in Power Query. Can you please advise the best way to achieve this ?
If that query is not needed by other queries, you can just right click on that query in the query editor and uncheck "Include in Refresh". That way, only your only tables will refresh.
Pat
1 Reply
If that query is not needed by other queries, you can just right click on that query in the query editor and uncheck "Include in Refresh". That way, only your only tables will refresh.
Pat