Pro Power BI Architecture : Development, Deployment, Sharing, and Security for Microsoft Power BI Solutions / by Reza Rad.

Format:

Book

Author/Creator:

Rad, Reza, author.

Language:

English

Subjects (All):

Microsoft software.

Microsoft .NET Framework.

Database management.

Microsoft.

Database Management.

Local Subjects:

Microsoft.

Database Management.

Physical Description:

1 online resource (763 pages)

Edition:

2nd ed. 2023.

Place of Publication:

Berkeley, CA : Apress : Imprint: Apress, 2023.

Summary:

This book provides detailed guidance around architecting and deploying Power BI reporting solutions, including help and best practices for sharing and security. You’ll find chapters on dataflows, shared datasets, composite model and DirectQuery connections to Power BI datasets, deployment pipelines, XMLA endpoints, and many other important features related to the overall Power BI architecture that are new since the first edition. You will gain an understanding of what functionality each of the Power BI components provide (such as Dataflow, Shared Dataset, Datamart, thin reports, and paginated reports), so that you can make an informed decision about what components to use in your solution. You will get to know the pros and cons of each component, and how they all work together within the larger Power BI architecture. Commonly encountered problems you will learn to handle include content unexpectedly changing while users are in the process of creating reports and building analyses, methods of sharing analyses that don’t cover all the requirements of your business or organization, and inconsistent security models. Detailed examples help you to understand and choose from among the different methods available for sharing and securing Power BI content so that only intended recipients can see it. The knowledge provided in this book will allow you to choose an architecture and deployment model that suits the needs of your organization. It will also help ensure that you do not spend your time maintaining your solution, but on using it for its intended purpose: gaining business value from mining and analyzing your organization’s data. You will: Architect Power BI solutions that are reliable and easy to maintain Create development templates and structures in support of reusability Set up and configure the Power BI gateway as a bridge between on-premises data sources and the Power BI cloud service Select a suitable connection type—Live Connection, DirectQuery, Scheduled Refresh, or Composite Model—for your use case Choose the right sharing method for how you are using Power BI in your organization Create and manage environments for development, testing, and production Secure your data using row-level and object-level security Save money by choosing the right licensing plan.

Contents:

Part I. Getting Started

1. Power BI Ecosystem and Components

2. Tools and Preparation

Part II. Development

3. Import Data or Schedule Refresh

4. DirectQuery

5. Live Connection

6. Composite Mode

7. DirectQuery to Power BI Dataset - 8. Choosing the Right Connection Type

9. Dataflows

10. Shared Datasets

11. Datamart.– 12. Multi-Developer Architecture

11. Hybrid Architecture using other Microsoft Services

12. DirectQuery to Power BI Dataset

13. Dataflow vs Dataset vs Datamart

14. Paginated Reports

15. Analyze in Excel

15. Development Tools

16. Real-time with Power BI

17. Aggregation

18. Incremental refresh and Hybrid tables

19- Power BI Development Best Practices

Part III. Deployment and Collaboration

20. Power BI service objects

21. Power BI report server.-22. Gateway and configurations

23. Licensing guide (and PPU)

24. Tenant settings

25. PowerShell Cmdlets for Power BI

26. REST API for Deployment and Administrations + .NET SDK

-27. Audit Log for the Tenant

28. XMLA endpoint

29. Power BI Sharing Individual Objects

30. Workspace Sharing

31. Power BI App

32. Publish to Web

33. Power BI Embedded

34. Secure Embed

35. Embed in SharePoint online and Teams

36. Compare sharing methods

37. Different types of Users in Power BI

38. Workspace Roles

39. Build Access Level

40. Workspace Structure and Architecture

41. Content Certification and Governance

42. Deployment pipelines

43. RLS and Dynamic RLS and OLS

44. Power BI Helper.

Notes:

Includes bibliographical references and index.

Other Format:

Print version: Rad, Reza Pro Power BI Architecture

ISBN:

9781484295380

1484295382

OCLC:

1393110317