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"),