Export n files in folder as n different query

[hegdesantosh]

I have imported the 10 excels files in Power Query, each of files are different from each other and DO NOT want to combine them. I need to extract each of these files into separate query in Power Query in single step. Please suggest the M Code to achieve this.

[lbendlin]

Not possible. Power Query does not support dynamic query generation. One workaround could be to bend the git integration and do the code multiplication on the outside.

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41