Description
Book SynopsisThis 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 b
Table of Contents
Introduction
Part I. Getting Started1. Power BI Ecosystem and Components2. Tools and Preparation
Part II. Development3. Import Data or Schedule Refresh4. DirectQuery 5. Live Connection6. Composite Mode7. Choosing the Right Connection Type8. Dataflows9. Shared Datasets10. Multi-Developer Architecture11. Hybrid Architecture using other Microsoft Services12. DirectQuery to Power BI Dataset13. Dataflow Development Architecture14. Analyze in Excel15. Development Tools16. Power BI Helper for Developers17. Dataset Types18. Realtime Power BI Solution19. Paginated Reports20. Power BI Templates21. Power BI Desktop Development Templates22. Incremental Refresh23. Big Data Considerations, Hybrid Tables, and Performance
Part III. Deployment24. Power BI Service Content25. Power BI Report Server26. Gateway27. Power BI Licensing Guide28. Power BI Premium29. Premium Per User30. Premium Settings and Configuration31. Tenant Settings32. Administrator Reports and Metrics33. Workspace Structure and Architecture34. Workspace Rules35. Deployment Pipeines36. REST API for Deployment and Architecture37. Power BI Helper for Deployment and Administration38. XMLA Endpoint
Part IV. Sharing and Security39. Governance40. Dashboard and Report Sharing41. Workspaces as Collaborative Environments42. Power BI Apps43. Embed Code and Publish to Web44. Embed in SharePoint Online45. Microsoft Teams Integration46. Power BI Embedded47. SharePoint Online Integration48. Microsoft Office49. Comparing Power BI Sharing Methods50. Usage Metrics Reports51. Usage Metrics using REST API52. Usage Metrics using Power BI Helper53. Row Level Security54. Dynamic Row Level Security55. Object-Level Security
