A lot of times, we don't connect to structured data bases for our Power BI related reporting. This is mostly because a huge chunk of reporting in most organizations today is still ad hoc reporting. Some other person's report may be the data that you need to create your own report.
This somewhat creates some level of "unstructuredness" in the kind of data we work with. Power Query is always there to bail us out, that we know for sure. Two of the buttons that oftentimes do the trick of putting structure into place are Transpose and Unpivot.
In this article, I will explain what they do, and what users need to watch out for to ensure they are used correctly.
Read more...