The purpose of this article is to outline a set of guidelines and recommended practices for managing Microsoft Power BI projects. This guide is primarily focused on the work performed by the IT-managed BI Solution Developers for formally-managed BI projects. Again, this guide is primarily focused on the work performed by the IT-managed BI Solution Developers for formally-managed BI projects. Topics included in this guide: Solution Architecture Managing Power BI Desktop Files Datasets and Reports Version Control & Lifecycle Management Workspace and App Management Data Model and Power Query Design Guidelines Dimensional Design Query Optimization Managing Dataset Size with Parameters Implicit and Explicit Measures If Users Need Excel, Give them Excel Certified & Shared Datasets Enterprise Scale Options

über Power BI Project Good and Best Practices — Paul Turley’s SQL Server BI Blog