Packt+ | Advance your knowledge in tech

You're reading from Microsoft Power BI Cookbook Creating Business Intelligence Solutions of Analytical Data Models, Reports, and Dashboards

Product type Paperback

Published in Sep 2017

Publisher Packt

ISBN-13 9781788290142

Length 802 pages

Edition 1st Edition

Languages

DAX

Tools

Power BI

Concepts

Business Intelligence

Author (1):

Powell

View More author details

Table of Contents (21) Chapters

Title Page

Credits

Foreword

About the Author

About the Reviewers

www.PacktPub.com

Customer Feedback

Preface

1. Configuring Power BI Development Tools FREE CHAPTER

2. Accessing and Retrieving Data

3. Building a Power BI Data Model

4. Authoring Power BI Reports

5. Creating Power BI Dashboards

6. Getting Serious with Date Intelligence

7. Parameterizing Power BI Solutions

8. Implementing Dynamic User-Based Visibility in Power BI

9. Applying Advanced Analytics and Custom Visuals

10. Developing Solutions for System Monitoring and Administration

11. Enhancing and Optimizing Existing Power BI Solutions

12. Deploying and Distributing Power BI Content

13. Integrating Power BI with Other Applications

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 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 and its source M queries contained in an Excel workbook is migrated to a Power BI dataset via the Import Excel Workbook to Power BI Desktop migration...