Forum Discussion
Split a table in Power Query
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
Thanks, lbendlin -- but perhaps I was unclear.
I don't mind creating the daughter tables manually in Power Query; I'm not looking for a dynamic solution.
I'm hoping that I can use the "master" table to create several well structured daughter tables in Power Query.
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
Thanks again, lbendlin -- that helps greatly!
🙂