Forum Discussion

jaychvn's avatar
jaychvn
New Member
3 years ago
Solved

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

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.

  • Anonymous's avatar
    Anonymous
    3 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    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