Breaking out table of tables

[Anonymous]

I'm new to PowerBI, I wrote a Python script to query and transform some data. The result is a table of tables where each row is a separate dataframe. This is what it looks like.

How can I split out the tables so that the query returns all 8 tables separately.

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

According to your description, if you want to get the seperate tables in the above table, simply create blank queries and modify the syntax in advanced editor like this:

let
    Source = #"Table"[Custom]{0}
in
    Source

Create eight queries and replace {0} with {1} to {7}. I attach my sample below for your reference.

let
    Source = #"Table"[Custom]{0}
in
    Source

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ToddChitt]

Duplicate the table as many times as you have tables. Filter each one ona different value of [Name], then for each, click the underlined word Table in [Value] column.

Just out of curiosity, were you not able to use any of the various Get Data source types? Seems Python is an end-around to something that Power BI already probably handles natively.