Expand Table Column in a new table

[Anonymous]

Hello, 

I am trying to build kind of table information for my DB and everything looks good so far.

and after running this query I get the following results

but  those profiles are objects so I can not work with them in POWER BI, but all what i get in just a text with the value [table].

so I thought is it possible to build a new table with all the expanded tables and add a column with the name of the Original table and repet it among the matching rows and then the next table from DB and so far. 
So I will have a table with Name of the table and columns and then the next table with the columns.  so I can use a filter during the visualization of the data in Power Bi. 
but how to do that I have no idea , how to make a loop that goes all over the Profile tables and expand them then add the name of the table to each match one. 

[v-ljerr-msft]

Hi @Anonymous,

Have you tried the solution provided by @MarcelBeug above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?

If you still have any question on this issue, feel free to post here.

Regards

[MarcelBeug]

You can expand the tables, as you already do in your query, however you return not that step after in, but the previous step.

So my suggestion would be to adjust #"Added Custom" to #"Expanded Profile" (after the first "in")..

Otherwise I wouldn't use 2 "let .. in" loops.