Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
Seb__187
Frequent Visitor

Table.Combine-Function doesnt recognize parameter values as table but as string

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!

 

 

 

2 REPLIES 2
Vijay_A_Verma
Most Valuable Professional
Most Valuable Professional

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]

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.