Microsoft Power BI Cookbook: Gain expertise in Power BI with over 90 hands-on recipes, tips, and use cases, Edition 2

Greg Deckler · Brett Powell

Sep 2021 · Packt Publishing Ltd

About this ebook

Publisher's note: This edition from 2021 is outdated and does not cover the most recent Power BI updates. A new third edition, updated to the latest release is now available in color Purchase of the print or Kindle book includes a free eBook in the PDF format.Key Features

• Update your knowledge with new recipes for query optimization, aggregation tables, Power BI API, and paginated reports
• Work with recipes across diverse Power BI platforms including the Power BI Service and Mobile Applications
• Implement custom solutions with M and DAX languages through actionable guidance and proven development techniques

Book DescriptionThe complete everyday reference guide to Power BI, written by an internationally recognized Power BI expert duo, is back with a new and updated edition. Packed with revised practical recipes, Microsoft Power BI Cookbook, Second Edition, helps you navigate Power BI tools and advanced features. It also demonstrates the use of end-to-end solutions that integrate those features to get the most out of Power BI. With the help of the recipes in this book, you’ll gain advanced design and development insight, practical tips, and guidance on enhancing existing Power BI projects. The updated recipes will equip you with everything you need to know to implement evergreen frameworks that will stay relevant as Power BI updates. You’ll familiarize yourself with Power BI development tools and services by going deep into the data connectivity, transformation, modeling, visualization, and analytical capabilities of Power BI. By the end of this book, you’ll make the most of Power BI’s functional programming languages of DAX and M and deliver powerful solutions to common business intelligence challenges.What you will learn

• Cleanse, stage, and integrate your data sources with Power Query (M)
• Remove data complexities and provide users with intuitive, self-service BI capabilities
• Build business logic and analysis into your solutions via the DAX programming language and dashboard-ready calculations
• Implement aggregation tables to accelerate query performance over large data sources
• Create and integrate paginated reports
• Understand the differences and implications of DirectQuery, live connections, Import, and Composite model datasets
• Integrate other Microsoft data tools into your Power BI solution

Who this book is for

If you’re a BI professional who wants to up their knowledge of Power BI and offer more value to their organization, then this book is for you. Those looking for quick solutions to common Power BI problems will also find this book an extremely useful resource. Please be aware that this is not a beginner’s guide; you’ll need a solid understanding of Power BI and experience working with datasets before you dive in.

About the author

Greg Deckler is a seven-time Microsoft MVP for Data Platform and an active member of the Columbus Ohio IT community, having founded the Columbus Azure ML and Power BI User Group (CAMLPUG) and presented at many conferences and events throughout the country. An active blogger and community member interested in helping new users of Power BI, Greg actively participates in the Power BI community, having authored over 200 Power BI Quick Measures Gallery submissions and over 7,500 authored solutions to community questions. Greg is also vice president at a global consulting firm.

Brett Powell has been a Microsoft business intelligence consultant since 2015 and is the author of the first editions of Mastering Microsoft Power BI and the Microsoft Power BI Cookbook. Originally known for his Insights Quest blog, Brett has primarily focused on helping organizations of diverse sizes and industries more effectively and efficiently utilize Power BI. He has led or contributed to projects as a technical architect, developer, and administrator encompassing all core Power BI features and use cases from large-scale enterprise BI solutions to enabling team and self-service BI