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
bilalg
Regular Visitor

Automatic Query Creation from Table Column

Hey everyone,

 

First time here. I looked for an answer in the community but couldn't find it. I have received a data from an external database in Power BI. Received data is as a flat list of records. I grouped these records by their 'category' attribute. Because each record belonging to the same category have the same record structure. So it makes sense to have them as a separate tables. To come to my question: Now I have a table with one column being the category names, the second column being the data itself.

 

bilalg_0-1687463328064.png

I want to convert each of these tables into separate queries. I can do so by right clicking on tables, and selecting "Add as New Query" option but this is not very future proof. Because. once my data gets updated, I might have more categories. And manually converting tables as new queries can be time consuming once I have more than 30 rows.

 

So question is, is there a way to automate this process? Convert each table value in "all_data" column and add them as a new query?

 

Any help is welcome. Thanks!

 

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

Hi @bilalg 

 

I'm afraid it is not possible to add new queries from table values in a column of an existing query automatically. New queries can only be added manually at present. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

View solution in original post

1 REPLY 1
v-jingzhang
Community Support
Community Support

Hi @bilalg 

 

I'm afraid it is not possible to add new queries from table values in a column of an existing query automatically. New queries can only be added manually at present. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

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.