Pro Power BI Architecture

Architect and deploy a Power BI solution. This book will help you understand the many available options and choose the best combination for hosting, developing, sharing, and deploying a Power BI solution within your organization. Pro Power BI Architecture provides detailed examples and explains the different methods available for sharing and securing Power BI content so that only intended recipients can see it. Commonly encountered problems you will learn to handle include content unexpectedly changing while users are in the process of creating reports and building analysis, methods of sharing analyses that don't cover all the requirements of your business or organization, and inconsistent security models. The knowledge provided in this book will allow you to choose an architecture and deployment model that suits the needs of your organization, ensuring that you do not spend your time maintaining your solution but on using it forits intended purpose and gaining business value from mining and analyzing your organization's data. What You'll Learn:

• Architect and administer enterprise-level Power BI solutions
• Choose the right sharing method for your Power BI solution
• Create and manage environments for development, testing, and production
• Implement row level security in multiple ways to secure your data
• Save money by choosing the right licensing plan
• Select a suitable connection type-Live Connection, DirectQuery, or Scheduled Refresh-for your use case
• Set up a Power BI gateway to bridge between on-premises data sources and the Power BI cloud service

Autorentext
Reza Rad is an author, speaker, trainer, and consultant. He is known worldwide for his expertise in Microsoft BI technologies. He is an invited speaker at the world's best and biggest SQL Server and BI conferences, such as the PASS Summit, PASS Rally, SQLBits, TechEd, Ignite, Microsoft Data Insight Summit, and more. He has authored several books on BI topics, and he has more than 15 years of experience with Microsoft's BI offerings. Reza is also a Microsoft Certified Trainer, and has experience training and consulting to the largest BI teams in the world. He is a Microsoft SQL Server MVP focused on BI and Data Analysis. He is the author of the Power BI online book, Power BI from Rookie to Rock Star.

Inhalt
Introduction
Part I: Getting Started1. Power BI Components2. Tools and Preparation
Part II: Power BI Service3. Power BI Service Content4. Gateway5. Import Data or Schedule Refresh6. DirectQuery 7. Live Connection8. Choosing the Right Connection Type
Part III: Sharing and Security9. Dashboard Sharing10. Workspaces as a Collaborative Environment11. Power BI Apps12. Publish to Web13. Embed in SharePoint Online14. Power BI Embedded15. Power BI Sharing Methods16. Row Level Security17. Dynamic Row Level Security
Part IV: Administration and Licensing18. Patterns for Dynamic Row Level Security19. Row Level Security with Analysis Services Live Connection20. Power BI Administrator Configuration21. Usage Metrics
Part V: Integration22. Power BI Licensing Guide23. Power BI Premium24. PowerPoint Integration with Power BI25. Power BI and Excel26. Power BI Report Server
Part VI: Architecture27. SQL Server Reporting Services28. Real-time Streaming with Power BI29. Power BI REST API30. Power BI Architecture Guidelines