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 ,
After my simple test, the direct connection mode is possible to unpivot columns.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.