Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register 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 |
|---|---|
| 15 | |
| 6 | |
| 6 | |
| 5 | |
| 5 |