Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! 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]
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!