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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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