Generate dynamic number of tables (Excel Power Query)

[pzyyc]

Is there a way to create a dynamic number of power query tables based on the number of rows in a parameter table? I have an "Admin" sheet that contains a parameter table with 1 column "EntityName". and a fact table (with EntityName) as one of the fields. The user will input the entity names into the parameter table and click generate sheets. Using VBA, a sheet will be created for each row in the parameter table. I want to be able to output a table in each of the generated sheets that filters the fact table by the entity for each sheet. For example if 2 sheets were created (Entity A and Entity B), I would want to output a table on the Entity A sheet that is a filtered fact table for only EntityName = "Entity A". Same for Entity B. Any ideas if this is possible/if you see a better solution using only PowerQuery (rather than VBA)??

[lbendlin · Accepted solution]

No, you cannot create dynamic queries / partitions in Power Query.