Forum Discussion

LaylaDantiandou's avatar
LaylaDantiandou
Frequent Visitor
2 years ago
Solved

"List may contain extra values" warning message

Hello all,   After unpivoting some columns in order to combine them, I note that the "Attribute" column generates the above-referenced "extra value" message when I look at the filter dropdown for t...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    2 years ago

    I can reproduce this message by unpivoting a table with many columns:


    Here's the sample query I'm using:

    let
    Source = Table.FromColumns(List.Transform({0..2000}, each {_})),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Column1"}, "Attribute", "Value")
in
    #"Unpivoted Other Columns"

     

    I'm pretty sure it's just a warning that the preview you're seeing in the dropdown list is not necessarily complete but should still show up when you load the query and it does the logic fully. I do get all 2000 rows when I load the query above.

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
2 years ago

I can reproduce this message by unpivoting a table with many columns:


Here's the sample query I'm using:

let
    Source = Table.FromColumns(List.Transform({0..2000}, each {_})),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Column1"}, "Attribute", "Value")
in
    #"Unpivoted Other Columns"

 

I'm pretty sure it's just a warning that the preview you're seeing in the dropdown list is not necessarily complete but should still show up when you load the query and it does the logic fully. I do get all 2000 rows when I load the query above.

  • LaylaDantiandou's avatar
    LaylaDantiandou
    Frequent Visitor
    2 years ago

    Thank you so much for your swift reply, AlexisOlson .  I'm somewhat of a newb and don't know much M code, but I will fiddle around with what you presented (and learn more M code!).  I agree with your conclusion, however.