Solved: Re: Unpivot error

Anonymous · ‎05-22-2019

Trying to unpivot a few columns and when it's finished, all data fields are showing the word error but I can't find the actual error message.

I've used unpivot before in pbi with no issues and don't know what's causing this recent issue

Anonymous · ‎05-23-2019

I got it to work. Deleted every column I didn't need and that did it

View solution in original post

Anonymous · ‎05-22-2019

can you share an sample of the data that is producing this error?

Anonymous · ‎05-23-2019

I got it to work. Deleted every column I didn't need and that did it

parry2k · ‎05-22-2019

@Anonymous very hard to say what is going on, can you share sample data and any steps you are doing in power query?

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.