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 nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
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]
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 3 | |
| 3 | |
| 2 |
| User | Count |
|---|---|
| 12 | |
| 6 | |
| 6 | |
| 5 | |
| 5 |