Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Performance issue: query much slower when using the result of another query as parameter

Hi,   I noticed some weird performance issues when using a query as parameter. I have an Excel with - tab "Data", containing some sample data - tab "DATADEF", containing a matrix with some defin...
Need Help
  • slorin's avatar
    slorin
    2 years ago

    Hi

    Try with List.Buffer 

    let
    Source = Excel.CurrentWorkbook(){[Name="Table18"]}[Content],
ListBuffer = List.Buffer("DATADEF-PAND-query"),
    #"Merged Columns" = Table.CombineColumns(Source,ListBuffer,Combiner.CombineTextByDelimiter(" | ", QuoteStyle.None),"PAND")
in
    #"Merged Columns

    Stéphane

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi slorin ,

 

Unfortunatly this gives an error

Expression.Error: We cannot convert the value "DATADEF-PAND-query" to type List.
Details:
    Value=DATADEF-PAND-query
    Type=[Type]

 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

typo

it should be

ListBuffer = List.Buffer(#"DATADEF-PAND-query"),