Passing table source as variable - Power BI

Question

I m trying to use source string from a variable and i m getting an error that i can not convert string to list.

I have the below step as source:

= Table.Combine({#"File 2023", #"File 2024", #"File 2025"})

I create a table and import this the below string as a value

{#"File 2023", #"File 2024", #"File 2025"}

Variable called cnsListcreated and the string succesfully passed into the variable.

When i use = Table.Combine(cnsList) i get the error that i can not use text as list.

Any ideas?

Answer

Create a blank query and paste:

={#"File 2023", #"File 2024", #"File 2025"}

This will generate a list. Rename the list to FileList. Use as follows:

= Table.Combine(FileList)

Answer 1

Try this:

Table.Combine(Expression.Evaluate(cnsList, #shared))