create multiple tables with multiple advance editor query in power bi automatically

[jaychvn]

I want to create multiple tables with using multiple advance editor queries in power bi.

I have a data containing 2 columns. One having table_name which should be referred as table name and second is defined M-query which should be used for creating new table in advanced editor.

so each row with table name and query to generate table. I wanted to created around 1k+ tables so thought of checking if we can use something to do the same.

[v-shex-msft · Accepted solution]

Hi @jaychvn,

Current power bi does not support automatically create query tables.
If you meant to loading multiple table records in one query table, it is possible. You can add a custom column with data connector to invoke current row column values and power bi will stored these results with table format.

Regards,

Xiaoxin Sheng