Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Hello everyone,
I have different tables which were combined by the Table.Combine-Function. That works properly.
Now i want to make this dynamic in order to easily add or remove some of the tables if neccessary.
Therefore I tried to create a Parameter which contains the names of the tables which should be combined.
But unfortunately they Table.Combine-Function recognizes the names of the tables as strings and not as tables and is therefore not able to process the input.
I always get an Expression.Error the value couldnt be transformed into a table.
Does anybody know how to fix this?
Thank you in advance!
See below an example of a single table.
let
T = Expression.Evaluate(Param, #shared),
Source = Table.Combine({t1,T})
in
Source
I need to see what does your parameter contain in case of multiple tables
Thank you for your reply!
My parameter contains for example "Table_A, Table_B, Table_C, ..."
The Table.Combine-Function looks like Table.Combine({#"prior step", Parameter})
Then the error message the value ""Table_A, Table_B, Table_C"" couldnt be converted into typ table appears. Details value=Table_A, Table_B, Table_C
Type=[Type]
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.