Book Image

Microsoft Power Platform Enterprise Architecture - Second Edition

By : Robert Rybaric
Book Image

Microsoft Power Platform Enterprise Architecture - Second Edition

By: Robert Rybaric

Overview of this book

This book is for enterprise architects and decision makers who design solutions for complex business requirements. It teaches you how to use architectural best practices and methodologies to optimize an enterprise-grade solution. You'll gain an understanding of the tools available in the Power Platform suite and how to integrate them seamlessly with various Microsoft 365 and Azure components to create a tailor-made solution. Progressing through the book, you'll discover how to address application lifecycle management, security, extensibility, and data migration. This includes Power BI, which often requires a separate approach to the rest of the Power Platform. This book provides you with practical, essential, and concise information. It follows a complete, end-to-end example in every chapter, with diagrams that illustrate the intricacies of Microsoft cloud structure. It has been created by an experienced enterprise architect who actively creates solutions using Microsoft technology. By the end of this book, you'll have the strategic perspective of an enterprise architect to make accurate architectural decisions for your complex Power Platform projects. Unlike many other overwhelmingly long and unstructured resources, this book covers essential concepts using one concise yet practical example that is revisited throughout the book. You’ll develop the skills you need to architect, design, and manage a complex solution as you follow the journey of a fictitious enterprise customer as they enter the world of Power Platform. Throughout the book, you’ll discover how to combine the functionality of Microsoft Power PI, Power Automate, Power Apps, and Power Virtual Agents with various methodologies to effectively address application lifecycle management, security, and extensibility. You'll also learn how to overcome common challenges in migrating data to and from Microsoft Power Platform using proven techniques. By the end of this Microsoft book, you’ll have the strategic perspective of an enterprise architect, enabling you to make accurate architectural decisions for your complex Power Platform projects.
Table of Contents (18 chapters)
Free Chapter
1
Section I: The Basics
4
Section II: The Architecture
8
Section III: The Implementation
15
Other Books You May Enjoy
16
Index
Appendix

Understanding the data migration tools and techniques

There are several ways to accomplish data migration to Dataverse. The Dataverse platform itself offers some out-of-the-box possibilities; however, they only cover less complex migration scenarios. For the most complex scenarios, an external solution needs to be considered, as you’ll learn in the following sections.

Entering data manually

For the smallest data volumes in which there are just a few records, the easiest and fastest way to migrate data is to manually enter it. Any semi-automated or automated data import would just take more effort and time to implement, compared to simple manual data entry.

Using Excel files

The simplest way to import data into a Dataverse table is to use Excel’s export feature. Dataverse applications allow you to export data from any table into Excel. There are several export possibilities, but for importing data, the Static Worksheet option needs to be used since it...