Power BI Report Server Architecture, Components and Basics
$14.99
Minimum price
$49.99
Suggested price

Power BI Report Server Architecture, Components and Basics

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.

About the Author

Vishal Pawar, Ph.D.
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.

Table of Contents

  • Acknowledgement
  • About Author - Dr. Vishal Pawar, Ph.D.
  • Reza Rad
    • About Reza
    • Foreword by - Reza Rad
  • Vivek Patel
    • About Vivek
    • Foreword by - Vivek Patel
  • Erich DeJesus
    • About Erich
    • Review by - Erich DeJesus
  • Dr. Sonal Pawar, Ph.D.
    • About Sonal
    • Edit and publish by - Dr. Sonal Pawar, Ph.D.
  • Chapter One : Ecosystem of Power BI Report Server with components
    • 1 - Introduction to Enterprise Power BI Ecosystem
    • 2 - The key aspect for the technology ecosystem
    • 3 - Enterprise Reporting Ecosystem Structure
      • 3-I - Enterprise Reporting Structure
      • 3-II - Report General Design and Pattern
      • 3-III - Reporting Access hierarchy and security
      • 3-IV - Reporting Charters and Definition
    • 4 - Enterprise Reporting for Executive Oversite
      • 4-I - Overall enterprise health
      • 4-II - Long term decision-making report
      • 4-III - High-level system monitoring and reporting
    • 5 - Enterprise Reporting Infrastructure
      • 5-I - Security Report
      • 5-II - Policy and compliance Report.
      • 5-III - Software and Hardware Reports
    • 6 - History of Power BI Report Server
    • 7 - Defining Power BI Report Server
      • 7-I - Power BI Report Server in enterprise
    • 8 - Power BI Desktop
      • 8-I - What is Power BI Desktop?
      • 8-II - Understanding Power BI Desktop Optimized?
      • 8-III - Costing of Power BI Desktop?
    • 9 - Power BI Pro
      • 9-I - How much does Power BI Pro cost?
      • 9-II - How are Power BI Pro Services related to Power BI Report Server ecosystem?
    • 10 - Power BI Premium
      • 9-I - How much does Power BI Premium cost?
      • 9-II - How is the Power BI Premium related Power BI Report Server ecosystem?
    • 11 - Report Builder
      • 9-I - How much does Power BI Report Builder Cost?
      • 9-II - What is the difference between Report Builder and Power BI Report builder?
      • 9-III - What are the top features of Power BI Report Builder?
    • 12 - Integration with SQL Server Ecosystem
      • 12-I - How is SQL Server related to Power BI Report Server ecosystem?
    • 13 - Integration with Power Platform Ecosystem
      • 13-I - What is a Power Platform?
      • 13-II - How is Power Platform Integration related to Power BI Report Server ecosystem?
    • 14 - Integration with Azure Ecosystem
      • 14-I - What is Azure?
      • 14-II - How is Azure Ecosystem related to Power BI Report Server ecosystem?
    • 15 - Integration with Excel and Office Online Server
      • 15-I - What is the online office server?
      • 15-II- How are Office Online Server and Power BI Report Server related?
    • Summary
  • Chapter Two : Architecture facets for Power BI Report Server
    • 1 - The Architecture of Power BI Report Server
      • 1 - A - Report Development | Analyze and Author
      • A-1 - Excel Analytic report | Microsoft Excel
      • A-2 - Power BI Report | Power BI Desktop
      • A-3 - Mobile Report | SQL Server Mobile Report Publisher
      • A-4 - Paginated Report | Report Builder
      • A-5 - Paginated Report | SQL Server Report Builder
      • A-6 - Paginated Report | SQL Server Data Tools Report Designer
      • 1 - B - Deliver | Publish
      • B-1 - On-Premises | Report Server
      • B-2- On-Cloud | Power BI
      • 1 - C - Consume | View
      • C-1 - Power BI Report Server Web Portal
      • C-2 - Power BI Cloud Web Portal (PowerBI.com)
      • C-3 - Mobile App
      • C-4 - Admin View
      • C-5 - Embed in other technology | SharePoint (Embed)
    • 2 - Power BI Report Server Licensing and Edition
      • 2-I - Power BI Licensing
      • 2-II- Power BI Premium
      • 2-III - SQL server
      • 2-IV - Power BI Licensing cost
      • 2-V - Evaluation edition
      • 2-VI - Developer edition
      • 2-VII - Power BI premium edition
      • 2-VIII - SQL server EA+SA edition
    • 3 - Power BI Report Server Modern Lifecycle Policy
      • 3-I - PBIRS Release
      • 3-II - PBIRS Update
    • 4 - Power BI Report Server Version history and support
      • 4-I - PBIRS Version Support – A start date and support end date in tabular format
      • 4-II - PBIRS Version Yearly Summary for version
      • 4-III - PBIRS Version Support – A start date and support end date on the timeline
    • 5 - Power BI Report Server Release Summary
      • 5-I - PBIRS version and update
      • 5-II - PBIRS release and version update in time series
      • 5-III - PBIRS release and version update in tabular format
    • 6 - Power BI Report Server Scalability
      • 6-I - Power BI Report Server Scalability using Scale-Out configuration
      • 6-II - Power BI Report Server Scalability using Load Balancer
      • 6-III - Power BI Report Server Scalability using Load Balancer using On-Prem
      • 6-IV - Power BI Report Server Scalability using Load Balancer Cloud
    • 7 - Power BI Report Server Security
    • 8 - Browser support for Power BI Report Server
    • 9 - Power BI Report Server report types
    • 10 - Content delivery in Power BI Report Server
    • 11 - Difference of Power BI Server VS SSRS VS Services
      • 11-I - General difference - 1 to 9
      • 11-II - General difference - 9 to 34
      • 11-III - General difference - 35 to 50
      • 11-IV - Components specific difference
    • 12 - Architecting Power BI Report Server implementation for Enterprise
      • 12 - I - Architecture flow for architecture planning
    • Summary
  • Chapter Three : Installation of Power BI Report Server and components
    • 1 - General Installation Planning and Details
      • I - Installation Planning
      • II - Server components
      • III - SQL Server components
    • 2 - SQL Server
      • I - Why do we need SQL Server?
      • II - General Pre-Requisite for SQL Server installation
      • III - Download installation setup for SQL Server
      • IV - Installation step by step for SQL Server
      • V - Installation verification for SQL Server
    • 3 - SQL Server Management Studio SSMS for Developers
      • I - Why do we need SQL Server Management Studio (SSMS)?
      • II - General Pre-Requisite for SQL Server Management Studio (SSMS) installation
      • III - Download installation setup for SQL Server Management Studio SSMS
      • IV- Installation step by step for SQL Server Management Studio SSMS
      • V - Installation verification for SQL Server Management Studio SSMS
    • 4 - Power BI Report Server
      • I - Download installation setup for Power BI Report Server
      • II - Installation step by step for Power BI Report Server
      • III - Configuration Manager setup for Power BI Report Server
      • IV- Installation verification for Power BI Report Server
    • 5 - Power BI Desktop Optimized for Report Server
      • I - Why do we need Power BI Desktop Optimized for Report Server?
      • II - General Pre-Requisite for Power BI Desktop Optimized for Report Server installation
      • III - Download installation setup for Power BI Desktop Optimized for Report Server
      • IV - Installation step by step for Power BI Desktop Optimized for Report Server
      • V - Installation verification for Power BI Desktop Optimized for Report Server
    • 6 - Report Builder
      • I - Why do we need Report Builder?
      • II - Download installation setup for Report Builder
      • III - Installation step by step for Report Builder
      • IV- Installation verification for Report Builder
    • 7 - Installation of Mobile Report Publisher
      • I - Why do we need Mobile Report Publisher?
      • II - Download installation setup for Mobile Report Publisher
      • III - Installation step by step for Mobile Report Publisher
      • IV - Installation verification for Mobile Report Publisher
    • 8 - Power BI Mobile
      • I - Why do we need Power BI Mobile?
      • II - Download installation setup for Power BI Mobile
      • III - Installation step by step for Power BI Mobile
      • IV - Installation verification for Power BI Mobile
    • 9 - Additional Installation components
    • Summary
  • Chapter Four : Report Web Portal Walkthrough
    • 1 - Power BI Report Server Portal Overview
      • I - What is Report Server Portal?
      • II - Where we can find the Report Server Portal Link
      • III - Overall Portal Navigation Big Picture – Site level
    • 2 - Portal Navigation one by one at site level
      • I - How to customize your favorites in Power BI Report Server Web Portal
      • II - How to browse reports and components in Power BI Report Server Web Portal
      • III - Where to find your report name on Power BI Report Server Web Portal
      • IV - How to navigate back to the home state in Power BI Report Server Web Portal
      • V - How to search inside Power BI Report Server Web Portal
      • VI - Administrator setting for Power BI Report Server Web Portal
      • VII - How to download tools in Power BI Report Server Web Portal
      • VIII - How to Get Help from Power BI Report Server Web Portal
      • IX - How can I get started in Power BI Report server?
      • X - Where can I find community help for the Power BI report server?
      • XI - How to get started on developers’ resources for core development?
      • XII - Where to find information to migrate from SSRS into PBIRS?
      • XIII - How to find which version of the Power BI report server you are using?
    • 3 - Overall Portal Navigation Big Picture – Report level
    • 4 - Portal Navigation one by one at Report level
      • I - Folder Navigation
      • II - How to create a Folder on Power BI Report Web Portal
      • III - How to manage existing folders on Power BI Report Server?
      • IV - How to provide access to the folder in Power BI Report Server
    • 5 - Power BI Report Server Site setting
      • I - Site setting – General tab
      • II - Site setting on Power BI Report Server
      • III - Site setting - Branding tab
    • 6 - Site setting – Schedules tab
      • I - Create a New Schedule in Report Server
      • II - Behind the scenes, Server Schedule create Job in SQL Server
      • III - How to edit existing schedule on Power BI Report Server
      • IV - Schedule Status when SQL Agent is not running
    • 7 - Site setting – Security tab
      • I - Add a Security Group/User to Report Server
      • II - Edit existing Security Group/User Access to Report Server
      • III - Delete security Group/User access from Report Server
    • Summary
  • Chapter Five : Power BI Report Server - Report Development
    • 1 - Create your First Power BI Desktop Optimized report
    • 2 - Publish your First report on Power BI Report Server
    • 3 - Report View on Report Server
    • 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...

80% Royalties. Earn $16 on a $20 book.

We pay 80% royalties. That's not a typo: you earn $16 on a $20 sale. If we sell 5000 non-refunded copies of your book or course for $20, you'll earn $80,000.

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

In fact, authors have earnedover $13 millionwriting, 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