Forum Discussion

adinezza's avatar
adinezza
Copper Contributor
Apr 01, 2022
Solved

Error "There weren't enough elements in the enumeration to complete the operation." when Pivoting

I have a .txt file that I am running through Power Query and into Excel.  The txt file is a simple format that has an item ID on one line and an error message on the next, eg: Item ABC Error Msg I...
excel
power bi
adinezza's avatar
adinezza
Copper Contributor
Apr 01, 2022
Thank you! I was able to use your method on my file, and it worked.
Do you know why my method gives the error, though? Do you need at least 3 columns for the pivot function to work?
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Apr 01, 2022

    adinezzaYour method probably works also if just add an index column.

Resources