Resources and standards for Power BI deployment and projects
To balance the advantages of ‘self-service business intelligence (BI)’ with the advantages of reliable IT processes requires respect for relevant best practices. Good policies need deliberate implementation.
- 2018-07 Power BI Governance and Deployment whitepaper published by Microsoft.
- Power BI list of Microsoft whitepapers
- Deploying and Managing Power BI Premium Capacities by Microsoft.
- 2019-08 Power BI project good and best practices by Paul Turley.
- 2020-07 Doing Power BI the Right Way a series by Paul Turley.
- 2019-10 Power BI cheat-sheet by Macaw.
- 2017-12 Checklist for Finalizing a Data Model in Power BI Desktop by Melissa Coates.
Agile software engineering methods, including formal testing and DevOps automation, are increasingly applied to Power BI. These links show what is possible today and give a preview of new features coming in 2020:
- 2018-09 Automated Testing for Power BI using Dax Studio on powerpivotpro.com.
- Power BI Sentinel - a DevOps tool for Power BI by Purple Frog Systems.
- 2018-12 Publishing Power BI resources via Azure DevOps by Maik van der Gaag.
- 2019-11 Versioning and CI+CD for Power BI with Azure DevOps by Marc Lelijveld.
- 2019-11 Power BI DevOps CD+CI pipelines Ignite preview, due March 2020 by Microsoft.
Power BI tools and utilities
- List of free tools curated by SQLBI.
- DAX formatter
- DAX Studio
- Power BI Helper by Radacad.
- Power BI Comparer by the BIccountant.
- ALM Toolkit by Christian Wade.
Migration from SQL Server Reporting Service (SSRS) to Power BI Service or Report Server
- 2091-01 How to migrate an existing SQL Server Reporting Services (SSRS) instance to an instance of Power BI Report Server by Microsoft
- 2019-10 A tool on GitHub supports migrating content from SQL Server Reporting Services to Power BI Service
- How to migrate existing native SSRS Reports to Power BI Report Server by Dhruvin Shah
Power BI Paginated Reports and Power BI Report Builder
Power BI paginated reports are optimized for printing, or PDF generation. They are ideal for operational reports, like sales invoices. In contrast, Power BI reports are optimized for exploration and interactivity.
- When to use paginated reports in Power BI, by Microsoft
- What are paginated reports in Power BI Premium? by Microsoft
- 2019-04 Power BI Paginated Report Builder desktop tool by Microsoft
- List of Microsoft blogs on Power BI Report Builder