Architecting Power BI Solutions in Microsoft Fabric

Master Power BI and Microsoft Fabric to design scalable, secure, and efficient business intelligence solutions

Free with your book: DRM-free PDF version + access to Packt's next-gen Reader*

Key Features:

- Make well-informed decisions while selecting the right Power BI component for a scenario

- Learn how to design secure and performant solutions using Power BI

- Familiarize yourself with the latest Power BI capabilities like AI features, Microsoft Fabric enhancements, and Git integration

- Purchase of the print or Kindle book includes a free PDF eBook

Book Description:

Business Intelligence (BI) tools like Power BI are used by a wide range of professionals, creating diverse and complex scenarios, and finding the right solution can be daunting, especially when multiple approaches exist for a single use case. The author distills his 17 years of experience on various data platform technologies in this book to walk you through various Power BI usage scenarios.

The book is structured around Power BI usage scenarios, such as developing solutions for corporate BI reporting, self-service BI reporting, and Power BI for data scientists and independent software vendors (ISVs). Each part highlights common data issues encountered in the usage scenario, the correct approach to solve the problems, and supporting technical guidance. The chapters also introduce you to some of the latest enhancements in Power BI, such as Microsoft Fabric integration with Power BI, AI features like Copilot, Power BI Git integration, and Power BI Governance features.

By the end of this book, you'll have learned how to design optimal solutions using Power BI components and pick the right tool for the job, while adhering to security and performance best practices.

What You Will Learn:

- Explore Power BI fundamentals and usage scenarios

- Get to grips with optimal data models and reports for corporate reporting

- Leverage AI while building self-service reporting solutions

- Discover AutoML, as well as Python and R integration features

- Develop expert solutions for ISVs using Power BI Embedded

- Understand Microsoft Fabric integration features for Power BI

Who this book is for:

This book is for anyone who uses Power BI at work. Solution architects, data engineers, Power BI administrators, and Power BI report developers will benefit from every section of the book. Business analysts and data scientists can use this book to learn about self-service BI features and data science capabilities, respectively. Although not mandatory, prior exposure to Power BI will help you get the most out of this book.

Table of Contents

- Decoding Power BI

- Power BI Licensing

- Understanding Collaboration and Distribution in Power BI

- Power BI Usage Patterns

- Deciding on the Storage Mode

- Deciding on an Intermediate Data Store

- Understanding Microsoft Fabric

- Managing Semantic Model Refresh

- Performing Optimizations in Power BI

- Managing Semantic Model Security

- Performing Power BI Deployments

- Leveraging Artificial Intelligence in Power BI

- Integrating Power BI with Office 365 Tools

- Uncovering Features of Power BI for Data Scientists

- Information Protection Using Microsoft Purview and Defender

- Designing Power BI Governance

- Managing Fabric Capacities