Book Image

Microsoft Power BI Cookbook

By : Author Test, Brett Powell
Book Image

Microsoft Power BI Cookbook

By: Author Test, Brett Powell

Overview of this book

Microsoft Power BI is a business intelligence and analytics platform consisting of applications and services designed to provide coherent, visual and interactive insights of data. This book will provide thorough, technical examples of using all primary Power BI tools and features as well as demonstrate high impact end-to-end solutions that leverage and integrate these technologies and services. Get familiar with Power BI development tools and services, go deep into the data connectivity and transformation, modeling, visualization and analytical capabilities of Power BI, and see Power BI’s functional programming languages of DAX and M come alive to deliver powerful solutions to address common, challenging scenarios in business intelligence. This book will excite and empower you to get more out of Power BI via detailed recipes, advanced design and development tips, and guidance on enhancing existing Power BI projects.
Table of Contents (14 chapters)

Migrating a Power Pivot for Excel Data Model to Power BI

As Power BI has become more mature as a product and as business users become more comfortable with the platform it's often beneficial to migrate data models (formerly Power Pivot) and M queries from Excel to Power BI. A table of 14 distinct advantages of Power BI over Excel is provided in the See also section of the Configuring Power BI Desktop options and settings recipe in the first chapter, and includes things like greater capacity (1 GB versus 250 MB) and support for Row-level Security (RLS). Additionally, from a data management and governance standpoint, it's preferable to consolidate data models to either Power BI and/or SSAS datasets and to limit Excel's role to ad hoc analysis such as pivot tables connected to datasets in the Power BI Service via Analyze in Excel.

In this brief recipe a data model...