Power Query is undeniably one of my favorite features of Power BI, and for that matter, Excel. Power Query packs a powerful punch for performing ETL (extract, transform, and load) tasks and it's user interface makes completing these tasks pretty simple without having to write any code. I won't expand…
Let me start this post by stating the obvious: data is the main focus of our data models and reporting. Without the data, well, the models and reporting would be pointless. But as necessary as the data is, often times I find that it's the small details in our data…
Allow me to start this article with a question: when you build a model in Power BI, do you think about the usability of that model? Rephrased, do you think about the user who is building a report on top of your model (including yourself) and the experience of that…