Forum Discussion

NMOORE's avatar
NMOORE
Helper II
2 years ago

Error Code Incorrect Syntax When Pivoting from SQL

Hi all,   I have the following error when I go to unpivot columns in power query. Everything works fine regarding access to the account and making other changes, it is only when I go to unpivot the...
Need Help
v-belled's avatar
v-belled
Regular Visitor
2 years ago

I have the same error as soon as I select 5 or more columns and then try to unpivot others cloumns...

  • NMOORE's avatar
    NMOORE
    Helper II
    2 years ago

    With me it was too many columns I was trying to pivot, I cannot confirm 100% but it was the only thing that made sense. I seperated them, unpivoted then appended, all has worked fine since