Dynamic name extraction.

Hi Anonymous 

Cool, I think there might be a better way.

In Query Editor.

1. Create a Blank Query and Past the below, into the Advanced Editor 
   

   let
       Source = PowerBI.Dataflows([])
   in
       Source

   this will create a table with all workspaces that are available to you.
2. Find the workspaceName and click on [Data] Column > "Folder", this will show you a list of all the dataflows within that workspace.
3. Find your workspace and click on [Data] Column > "Database", this will the list of all the tables within this dataflow.
4. Now, select entity ( your table names ) column and Data Column and Right Click > Remove Other Columns
5. you should have a table like below.
    
   All you need to do now is expanding your tables by clicking on the highlighted arrows and selecting the columns to expand.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

What are these tables sources and I assume that these are all individual queries?

Hi Anonymous 

Try something like this.

let
    Source = #shared,
    #"Converted to Table" = Record.ToTable(Source),
    #"Added Custom" = Table.AddColumn(#"Converted to Table", "Custom", each  Type.Is( Value.Type( [Value] ), type table)  ),
    #"Filtered Rows1" = Table.SelectRows(#"Added Custom", each not ([Name] = "Query1")),
    #"Filtered Rows" = Table.SelectRows(#"Filtered Rows1", each ([Custom] = true))
in
    #"Filtered Rows"

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.