Leanpub Header

Skip to main content
Go to Leanpub.comLeanpub

Power BI Report Server Architecture, Components and Basics

Dr. Vishal Pawar, Ph.D.

Experience the bliss of the on-prem architecture of the Power BI Report server and its technology 

The author is letting you choose the price you pay for this book!

Pick Your Price...
PDF
EPUB
WEB
About

About

About the Book

This book one-stop guide for acquiring Power BI Report Server in the enterprise. Readers will understand the general Power BI ecosystem, Power BI Report Server Components, and Learn the history behind the report server. Additionally, learning the Architecture aspects of Power BI Report Server, how you can apply this knowledge in Enterprise implementation with Editions, the lifecycle of a product and release summary.

Share this book

Categories

SQL Server

Feedback

Email the author

License

Creative Commons Attribution 4.0 International License

Price

Pick Your Price...

Minimum price

$14.99

$49.99

You pay

$49.99

Author earns

$39.99
$

All prices are in US $. You can pay in US $ or in your local currency when you check out.

EU customers: prices exclude VAT, which is added during checkout.

...Or Buy With Credits!

Number of credits (Minimum 1)

1
The author will earn $12.00 from your purchase!
You can get credits monthly with a Reader Membership

Author

About the Author

Dr. Vishal Pawar, Ph.D.

Dr. Vishal Pawar brings over fifteen years of expertise in analytics, AI, and BI consulting to his role as Vice President at Concretely.Ai. He also serves as a Guide and strategic Advisor at Strong Point Consulting and is a distinguished Co-Founder of four Canadian startups: CloudOMax Corp., EvalPro COE Indexer, Nuero SyncDMS GPT and LiveBit. His leadership extends to being the Co-Founder and Head Coach at MyCloud.Guide. Dr. Vishal is a highly recognized professional, being a 5-time Microsoft MVP (Most Valued Professional) and a 6-time Microsoft Certified Trainer. His credentials include over 15+ professional certifications from Microsoft and Scrum Alliance. An avid SQL and BI blogger, he holds a Ph.D. in Computer Science and an MBA in Information Systems. Beyond his professional achievements, Dr. Vishal is a dedicated father of two and committed to providing training to over 135K+ professionals globally, and well known international speaker at global conferences such as Microsoft Ignite.

Contents

Table of Contents

Acknowledgement

About Author - Dr. Vishal Pawar, Ph.D.

Reza Rad

  1. About Reza
  2. Foreword by - Reza Rad

Vivek Patel

  1. About Vivek
  2. Foreword by - Vivek Patel

Erich DeJesus

  1. About Erich
  2. Review by - Erich DeJesus

Dr. Sonal Pawar, Ph.D.

  1. About Sonal
  2. Edit and publish by - Dr. Sonal Pawar, Ph.D.

Chapter One : Ecosystem of Power BI Report Server with components

  1. 1 - Introduction to Enterprise Power BI Ecosystem
  2. 2 - The key aspect for the technology ecosystem
  3. 3 - Enterprise Reporting Ecosystem Structure
  4. 3-I - Enterprise Reporting Structure
  5. 3-II - Report General Design and Pattern
  6. 3-III - Reporting Access hierarchy and security
  7. 3-IV - Reporting Charters and Definition
  8. 4 - Enterprise Reporting for Executive Oversite
  9. 4-I - Overall enterprise health
  10. 4-II - Long term decision-making report
  11. 4-III - High-level system monitoring and reporting
  12. 5 - Enterprise Reporting Infrastructure
  13. 5-I - Security Report
  14. 5-II - Policy and compliance Report.
  15. 5-III - Software and Hardware Reports
  16. 6 - History of Power BI Report Server
  17. 7 - Defining Power BI Report Server
  18. 7-I - Power BI Report Server in enterprise
  19. 8 - Power BI Desktop
  20. 8-I - What is Power BI Desktop?
  21. 8-II - Understanding Power BI Desktop Optimized?
  22. 8-III - Costing of Power BI Desktop?
  23. 9 - Power BI Pro
  24. 9-I - How much does Power BI Pro cost?
  25. 9-II - How are Power BI Pro Services related to Power BI Report Server ecosystem?
  26. 10 - Power BI Premium
  27. 9-I - How much does Power BI Premium cost?
  28. 9-II - How is the Power BI Premium related Power BI Report Server ecosystem?
  29. 11 - Report Builder
  30. 9-I - How much does Power BI Report Builder Cost?
  31. 9-II - What is the difference between Report Builder and Power BI Report builder?
  32. 9-III - What are the top features of Power BI Report Builder?
  33. 12 - Integration with SQL Server Ecosystem
  34. 12-I - How is SQL Server related to Power BI Report Server ecosystem?
  35. 13 - Integration with Power Platform Ecosystem
  36. 13-I - What is a Power Platform?
  37. 13-II - How is Power Platform Integration related to Power BI Report Server ecosystem?
  38. 14 - Integration with Azure Ecosystem
  39. 14-I - What is Azure?
  40. 14-II - How is Azure Ecosystem related to Power BI Report Server ecosystem?
  41. 15 - Integration with Excel and Office Online Server
  42. 15-I - What is the online office server?
  43. 15-II- How are Office Online Server and Power BI Report Server related?
  44. Summary

Chapter Two : Architecture facets for Power BI Report Server

  1. 1 - The Architecture of Power BI Report Server
  2. 1 - A - Report Development | Analyze and Author
  3. A-1 - Excel Analytic report | Microsoft Excel
  4. A-2 - Power BI Report | Power BI Desktop
  5. A-3 - Mobile Report | SQL Server Mobile Report Publisher
  6. A-4 - Paginated Report | Report Builder
  7. A-5 - Paginated Report | SQL Server Report Builder
  8. A-6 - Paginated Report | SQL Server Data Tools Report Designer
  9. 1 - B - Deliver | Publish
  10. B-1 - On-Premises | Report Server
  11. B-2- On-Cloud | Power BI
  12. 1 - C - Consume | View
  13. C-1 - Power BI Report Server Web Portal
  14. C-2 - Power BI Cloud Web Portal (PowerBI.com)
  15. C-3 - Mobile App
  16. C-4 - Admin View
  17. C-5 - Embed in other technology | SharePoint (Embed)
  18. 2 - Power BI Report Server Licensing and Edition
  19. 2-I - Power BI Licensing
  20. 2-II- Power BI Premium
  21. 2-III - SQL server
  22. 2-IV - Power BI Licensing cost
  23. 2-V - Evaluation edition
  24. 2-VI - Developer edition
  25. 2-VII - Power BI premium edition
  26. 2-VIII - SQL server EA+SA edition
  27. 3 - Power BI Report Server Modern Lifecycle Policy
  28. 3-I - PBIRS Release
  29. 3-II - PBIRS Update
  30. 4 - Power BI Report Server Version history and support
  31. 4-I - PBIRS Version Support – A start date and support end date in tabular format
  32. 4-II - PBIRS Version Yearly Summary for version
  33. 4-III - PBIRS Version Support – A start date and support end date on the timeline
  34. 5 - Power BI Report Server Release Summary
  35. 5-I - PBIRS version and update
  36. 5-II - PBIRS release and version update in time series
  37. 5-III - PBIRS release and version update in tabular format
  38. 6 - Power BI Report Server Scalability
  39. 6-I - Power BI Report Server Scalability using Scale-Out configuration
  40. 6-II - Power BI Report Server Scalability using Load Balancer
  41. 6-III - Power BI Report Server Scalability using Load Balancer using On-Prem
  42. 6-IV - Power BI Report Server Scalability using Load Balancer Cloud
  43. 7 - Power BI Report Server Security
  44. 8 - Browser support for Power BI Report Server
  45. 9 - Power BI Report Server report types
  46. 10 - Content delivery in Power BI Report Server
  47. 11 - Difference of Power BI Server VS SSRS VS Services
  48. 11-I - General difference - 1 to 9
  49. 11-II - General difference - 9 to 34
  50. 11-III - General difference - 35 to 50
  51. 11-IV - Components specific difference
  52. 12 - Architecting Power BI Report Server implementation for Enterprise
  53. 12 - I - Architecture flow for architecture planning
  54. Summary

Chapter Three : Installation of Power BI Report Server and components

  1. 1 - General Installation Planning and Details
  2. I - Installation Planning
  3. II - Server components
  4. III - SQL Server components
  5. 2 - SQL Server
  6. I - Why do we need SQL Server?
  7. II - General Pre-Requisite for SQL Server installation
  8. III - Download installation setup for SQL Server
  9. IV - Installation step by step for SQL Server
  10. V - Installation verification for SQL Server
  11. 3 - SQL Server Management Studio SSMS for Developers
  12. I - Why do we need SQL Server Management Studio (SSMS)?
  13. II - General Pre-Requisite for SQL Server Management Studio (SSMS) installation
  14. III - Download installation setup for SQL Server Management Studio SSMS
  15. IV- Installation step by step for SQL Server Management Studio SSMS
  16. V - Installation verification for SQL Server Management Studio SSMS
  17. 4 - Power BI Report Server
  18. I - Download installation setup for Power BI Report Server
  19. II - Installation step by step for Power BI Report Server
  20. III - Configuration Manager setup for Power BI Report Server
  21. IV- Installation verification for Power BI Report Server
  22. 5 - Power BI Desktop Optimized for Report Server
  23. I - Why do we need Power BI Desktop Optimized for Report Server?
  24. II - General Pre-Requisite for Power BI Desktop Optimized for Report Server installation
  25. III - Download installation setup for Power BI Desktop Optimized for Report Server
  26. IV - Installation step by step for Power BI Desktop Optimized for Report Server
  27. V - Installation verification for Power BI Desktop Optimized for Report Server
  28. 6 - Report Builder
  29. I - Why do we need Report Builder?
  30. II - Download installation setup for Report Builder
  31. III - Installation step by step for Report Builder
  32. IV- Installation verification for Report Builder
  33. 7 - Installation of Mobile Report Publisher
  34. I - Why do we need Mobile Report Publisher?
  35. II - Download installation setup for Mobile Report Publisher
  36. III - Installation step by step for Mobile Report Publisher
  37. IV - Installation verification for Mobile Report Publisher
  38. 8 - Power BI Mobile
  39. I - Why do we need Power BI Mobile?
  40. II - Download installation setup for Power BI Mobile
  41. III - Installation step by step for Power BI Mobile
  42. IV - Installation verification for Power BI Mobile
  43. 9 - Additional Installation components
  44. Summary

Chapter Four : Report Web Portal Walkthrough

  1. 1 - Power BI Report Server Portal Overview
  2. I - What is Report Server Portal?
  3. II - Where we can find the Report Server Portal Link
  4. III - Overall Portal Navigation Big Picture – Site level
  5. 2 - Portal Navigation one by one at site level
  6. I - How to customize your favorites in Power BI Report Server Web Portal
  7. II - How to browse reports and components in Power BI Report Server Web Portal
  8. III - Where to find your report name on Power BI Report Server Web Portal
  9. IV - How to navigate back to the home state in Power BI Report Server Web Portal
  10. V - How to search inside Power BI Report Server Web Portal
  11. VI - Administrator setting for Power BI Report Server Web Portal
  12. VII - How to download tools in Power BI Report Server Web Portal
  13. VIII - How to Get Help from Power BI Report Server Web Portal
  14. IX - How can I get started in Power BI Report server?
  15. X - Where can I find community help for the Power BI report server?
  16. XI - How to get started on developers’ resources for core development?
  17. XII - Where to find information to migrate from SSRS into PBIRS?
  18. XIII - How to find which version of the Power BI report server you are using?
  19. 3 - Overall Portal Navigation Big Picture – Report level
  20. 4 - Portal Navigation one by one at Report level
  21. I - Folder Navigation
  22. II - How to create a Folder on Power BI Report Web Portal
  23. III - How to manage existing folders on Power BI Report Server?
  24. IV - How to provide access to the folder in Power BI Report Server
  25. 5 - Power BI Report Server Site setting
  26. I - Site setting – General tab
  27. II - Site setting on Power BI Report Server
  28. III - Site setting - Branding tab
  29. 6 - Site setting – Schedules tab
  30. I - Create a New Schedule in Report Server
  31. II - Behind the scenes, Server Schedule create Job in SQL Server
  32. III - How to edit existing schedule on Power BI Report Server
  33. IV - Schedule Status when SQL Agent is not running
  34. 7 - Site setting – Security tab
  35. I - Add a Security Group/User to Report Server
  36. II - Edit existing Security Group/User Access to Report Server
  37. III - Delete security Group/User access from Report Server
  38. Summary

Chapter Five : Power BI Report Server - Report Development

  1. 1 - Create your First Power BI Desktop Optimized report
  2. 2 - Publish your First report on Power BI Report Server
  3. 3 - Report View on Report Server
  4. 4 - Edit Power BI Desktop directly from Server

The Leanpub 60 Day 100% Happiness Guarantee

Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.

Now, this is technically risky for us, since you'll have the book or course files either way. But we're so confident in our products and services, and in our authors and readers, that we're happy to offer a full money back guarantee for everything we sell.

You can only find out how good something is by trying it, and because of our 100% money back guarantee there's literally no risk to do so!

So, there's no reason not to click the Add to Cart button, is there?

See full terms...

Earn $8 on a $10 Purchase, and $16 on a $20 Purchase

We pay 80% royalties on purchases of $7.99 or more, and 80% royalties minus a 50 cent flat fee on purchases between $0.99 and $7.98. You earn $8 on a $10 sale, and $16 on a $20 sale. So, if we sell 5000 non-refunded copies of your book for $20, you'll earn $80,000.

(Yes, some authors have already earned much more than that on Leanpub.)

In fact, authors have earned over $14 million writing, publishing and selling on Leanpub.

Learn more about writing on Leanpub

Free Updates. DRM Free.

If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).

Most Leanpub books are available in PDF (for computers) and EPUB (for phones, tablets and Kindle). The formats that a book includes are shown at the top right corner of this page.

Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.

Learn more about Leanpub's ebook formats and where to read them

Write and Publish on Leanpub

You can use Leanpub to easily write, publish and sell in-progress and completed ebooks and online courses!

Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks.

Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. (Or, if you are producing your ebook your own way, you can even upload your own PDF and/or EPUB files and then publish with one click!) It really is that easy.

Learn more about writing on Leanpub