Forum Discussion
error in pivot column
hi all..i am trying to pivot column"merged" but got error. can anyone advice where i have gone wrong... Thank you so much.
Hi,
See if my solution here helps - Append data from multiple worksheets of multiple workbooks where each worksheet has a different heading.
It's a bit difficult to debug because even though you have included the pbix, we don't have access to the source spreadsheet.
You could post the spreadsheet and tell us what your desired outcome is..
Having said that, the most common pivot error is "There were too many elements in the enumeration to complete the operation".
Is that what you have?
If so, it is usually because there's no aggregation on the pivot. So powerbi doesn't know how to cope with rows that have a similar 'key'.