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
torman119
New Member

Dynamically combine multiple tables into one table

I need to combine several tables from Azure storage dynamically into one table. I have for instance the following dynamically created tables:

userstable564736

userstable595743

userstable434534

othertable434342

othertable342856

 

I want to combine all tables which start with "userstable" into a single table. All these user tables have same schema. I don't know the full names of them upfront.

 

I tried this:

 

let
   Source = AzureStorage.Tables("https://storageaccount.table.core.windows.net"),
   userstables = List.Select(Source, Text.StartsWith([Name],"userstable")),
   combined = Table.Combine(userstables)
in
   combined

 

But I get error message

Expression.Error: There is an unknown identifier. Did you use the [field] shorthand for a _[field] outside of an 'each' expression?

 

Can somebody help?

    

1 ACCEPTED SOLUTION
torman119
New Member

Following solution works

 

let
   Source = AzureStorage.Tables("https://storageaccount.table.core.windows.net"),
   usertables = Table.SelectRows(Source, each Text.StartsWith([Name], "userstable")),
   combined= Table.Combine(usertables[Data])
in
   combined

View solution in original post

1 REPLY 1
torman119
New Member

Following solution works

 

let
   Source = AzureStorage.Tables("https://storageaccount.table.core.windows.net"),
   usertables = Table.SelectRows(Source, each Text.StartsWith([Name], "userstable")),
   combined= Table.Combine(usertables[Data])
in
   combined

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.