Forum Discussion
Split a table in Power Query
I'm trying to use PowerBI to recreate a data flow that I originally created in Tableau Prep and Tableau Desktop. I need to find a way to split a single large data table into several smaller tables...
You can reference queries - also check the "Query Dependencies" lineage view. Power Query may still decide to do some of the work twice when it suits its execution plans.
How Power Query Thinks: Taking the Mystery Out of Streaming and Query Folding (Video) | Ben Gribaudo
It is impossible (in the Power Query UI) to dynamically create queries. All partitions must be manually created.