Forum Discussion
Dynamically generate query tables
I'm importing data from an Azure Blob, and then generating some queries to share on the online portal. One of my intermediate queries generates a table of [name][table] like: Query: ALL TABLES
na...
Would table.split work?
Never mind. I have a similar dilemma and realized that this isn't solvable with just Power Query. Looking around the we, the answers seems to be to generate dynamic queries based on a list of values using VBA and pass the full set of m code into each one in the vba code..... though unless there is a specific reason for storing the queries in PQ, it might be easier to vba the entire solution.