Forum Discussion
Unpivot with Direct Query
Hi, Is it possible to UNPIVOT the data by using the Direct query in Power BI Desktop? Thank you,
Here is a post suggesting a work around using UNION()
https://stackoverflow.com/questions/50213905/is-it-possible-to-unpivot-in-power-bi-using-dax
Is the "Unpivot Column" button grayed out ? If so you will have to do the unpivot in the datasource.
kentyler , Thanks for your response, The Unpivot option is not grayed out but it is not letting me apply changes on the Query editor window. I guess, it is not possible at the moment and I may need to Unpivot on the source side.