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
Hi Anonymous ,
I found this article on internet
https://www.newtechdojo.com/unpivot-columns-in-power-bi/
I have used this concept in my case and it worked.
Please have a look.
best regards,
Gaurav Raj Singh
please consider Accept it as the solution to help the other members find it more quickly.
Anonymous , Thanks for your response, that article is about the unpivot the data with import mode but I need with the Direct mode connection.