Forum Discussion
Is it possible to create M query steps dynamically?
I have a scenario where I am needing to essentially create dynamic query steps based on a source table. In effect, this is "build-a-bear" but for Power Query. For example, let's say my query init...
Have you considered just loading all the data and then having all potential fitlers as slicers (or Filter panel options)?
You could also consider using paginated reports with parameters too.
Pat
Thanks for the response! This isn't a visualization-first report but actually needs to be fully dynamic on the query/ETL side as this could extend to complex scenarios like user-defined merges between tables and duplicate removals. My hope is to create a dataflow that will let users alter the data loaded into a table dynamically using an app as a kind of business logic/rules engine.