Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
jaychvn
New Member

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.

1 ACCEPTED SOLUTION
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

View solution in original post

1 REPLY 1
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

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.