As Power BI adoption grows, the clutter that comes with it also grows. Increasing number of datasets and reports, and duplicate content across workspaces and departments are a couple examples of what you would see. This clutter, of course, can be attributed to non-standard practices and the lack of governance and processes. So, when you start to put in the right processes and standardized practices, one functionality that you should consider is DirectQuery for PBI datasets and AS. We will look at the use case for this feature and how you can reduce on clutter, reuse existing models, and truly have a single source of the truth. Along the way we will be touching on architecture, security, and modeling best practices.