Blog

Revamped SSRS Has a Promising Future With Power BI

Microsoft has gained supremacy in analytics and real-time reporting with Power BI, currently available only as an online cloud service. A revamped on-premises SQL Server Reporting Services 2016 will deliver rich features, including a new UI, delivery of KPIs and HTML5-based reporting. The integration of these two services has much potential, but for now, is only a statement of direction.

The following is a synopsis of Redmond Magazine’s article, “SSRS Steps up in the Shadow of Power BI”. To read the full article, follow the link at the bottom of the page.

Last year, Microsoft released a major upgrade to its Power BI service and jumped to the head of the class in the crowded field of reporting, analytics, and self-service business intelligence (BI) in doing so. Microsoft reports that 5 million people now subscribe to the online tool for creating dashboards and reports. While Power BI is a good choice for people seeking a cloud-based solution, there is still demand for on-premises and hybrid solutions.

Microsoft’s next target is a rebuilt SQL Server Reporting Services (SSRS) to extend and unify Power BI’s on-premises reporting, analytics, and BI offerings. Microsoft is not only updating and enhancing SSRS, but it’s potentially unifying it with the cloud-based Power BI. These improvements to SSRS and Power BI are empowering more workers by allowing them to leverage data to gain insight and solve problems. Self-service BI should be all about providing a tool that analysts want to use and this is why the updated Power BI has done so well.

Historically, Microsoft has struggled with the presentation side of data, aside from Excel. The company first released SSRS in 2004 as a capable, minimalist reporting tool kit, which was a nice start, but enhancements dried up. A few years later, Microsoft released Performance Point, which, while powerful, never gained market acceptance and was incorporated into Microsoft SharePoint. As competitors moved into the self-service and analytics space, the world moved to more powerful, user-friendly reporting and BI tools. In response, SSRS was relegated to other departments and low-budget projects.

You might think that Microsoft would ignore the SQL Server legacy SSRS components or simply abandon them while the company encourages Office users to migrate to Office 365 cloud and Power BI. Luckily though, Microsoft is offering an alternative path that potentially strengthens the on-premises version of SSRS and sets it up as a bridge to the cloud for those who work with SQL Server. If done well, this path will unify SSRS with Power BI.

The obvious solution for Microsoft is to take advantage of the advances of Power BI while leveraging the existing base of SSRS and completely rebuild SSRS to support the Power BI desktop reports. Starting with Release Candidate 1 (RC1), a feature-complete, totally rebuilt SSRS has been revealed. It has a clean and modern interface and targets all browsers utilizing HTML5. In addition, the Power BI mobile apps enable mobile presentation for SSRS mobile reports and custom brand packages can be loaded into SSRS, allowing it to have a look and feel to match any organization. These enhancements are great, but they position SSRS and Power BI as separate, distinct platforms.

It makes sense for Microsoft to support a single unified report file format long term. Accordingly, both the Power BI team and the SSRS team have indicated that their long-term goal is for Microsoft to support the Power BI Desktop reports in the rebuilt SSRS. For now, SSRS 2016 is becoming a powerful, on-premises reporting platform on its own, while Power BI offers one of the best cloud-based solutions. A unified SSRS/Power BI solution would offer a solid on-premises solution with a clear path to the cloud, but there is no clear timeline as to when this will be possible.

Should you consider SSRS? It depends on whether your organization intends to rely solely on the cloud, only needs an on-premises solution, or is looking for a hybrid that supports both on-premises and cloud-based reports.

Power BI Only

  • Easy to use, powerful, inexpensive, and can access a vast array of on-premises and cloud-based data
  • Cloud-based so scalability issues don’t require more hardware, plus mobile support is automatic
  • Dashboard and reports display both in a browser and in the Power BI mobile app

SSRS On-Premises Only

  • UI has been completely overhauled with a modern design
  • Menus are well-designed and performance is improved
  • Ability to create a custom brand image
  • Reports are rendered using HTML5, allowing access by all modern browsers
  • Development tools are fragmented, relying on multiple tools for the creation of reports and components

Hybrid SSRS On-Premises with Power BI Cloud (not available yet)

  • An organization will be able to create a single Power BI Desktop report and deploy it both on-premises to SSRS and in the cloud
  • Only possible if SSRS in the future supports the Power BI report format

Source: SSRS Steps up in the Shadow of Power BI

Start Date
End Date
Day/Eve
Break Weeks
Track
Jan 23, 2023
Jul 27, 2023
Eve
4/3/23-4/7/23
5/22/23-5/26/23
7/3/23-7/7/23
CSSP-V
Jan 30, 2023
May 5, 2023
Day
3/6/23-3/10/23
4/10/23-4/14/23
CSSP-V
Feb 6, 2023
May 19, 2023
Day
3/27/23-3/31/23
FSCP-V
Mar 20, 2023
Jun 23, 2023
Day
4/24/23-4/28/23
5/22/23-5/26/23
CSSP-V
Apr 10, 2023
Jul 28, 2023
Day
5/29/23-6/2/23
7/3/23-7/7/23
FSCP-V
Apr 24, 2023
Oct 19, 2023
Eve
7/3/23-7/7/23
8/21/23-8/25/23
CSSP-V
May 15, 2023
Dec 14, 2023
Eve
7/3/23-7/7/23
9/4/23-9/8/23
11/20/23-11/24/23
FSCP-V
Jun 5, 2023
Sep 8, 2023
Day
7/3/23-7/7/23
8/7/23-8/11/23
CSSP-V
Jun 19, 2023
Oct 6, 2023
Day
7/3/23-7/7/23
9/4/23-9/8/23
FSCP-V
Jul 24, 2023
Jan 25, 2024
Eve
10/2/23-10/6/23
11/20/23-11/24/23
12/25/23-12/29/23
CSSP-V
Aug 14, 2023
Nov 17, 2023
Day
9/5/23-9/8/23
10/16/23-10/2/23
CSSP-V
Aug 28, 2023
Dec 15, 2023
Day
9/4/23-9/8/23
11/20/23-11/24/23
FSCP-V
Oct 30, 2023
Feb 2, 2024
Day
11/20/23-11/24/23
12/25/23-12/29/23
CSSP-V
Oct 30, 2023
May 2, 2024
Eve
11/20/23-11/23/23
3/4/23-3/7/23
CSSP-V
Nov 6, 2023
Mar 1, 2024
Day
11/20/23-11/24/23
12/25/23-12/29/23
1/29/24-2/2/24
FSCP-V
If you don't see the Cohort Start date you are looking for don't forget to check out our campus calendars.
CSSP-I: Cloud & Security Specialist Program (In-Person Modality)
CSSP-V: Cloud & Security Specialist Program (Live Virtual Modality)
FSCP-I: Full Stack Coding Program (In-Person Modality)
FSCP-V: Full Stack Coding Program (Live Virtual Modality)
Please note that Centriq will be closed on the following observed holidays: New Year’s Day, Memorial Day, Independence Day, Labor Day, Thanksgiving Day, the day following Thanksgiving Day, and Christmas Day.
Start Date
End Date
Day/Eve
Break Weeks
Track
Feb 29, 2024
Mar 24, 2024
Day
3/25/24-3/29/24
4/22/24-4/26/24
CSSP-I
May 13, 2024
Aug 16, 2024
Day
5/27/24-5/31/24
7/1/24-7/5/24
CSSP-I
Aug 19, 2024
Nov 22, 2024
Day
9/2/24-9/6/24
10/21/24-10/25/24
CSSP-I
Dec 2, 2024
Mar 14, 2025
Day
12/23/24-12/27/24
12/30/24-1/3/25
2/10/25-2/14/25
CSSP-I
If you don't see the Cohort Start date you are looking for don't forget to check out our online instructor-led calendar.
CSSP-I: Cloud & Security Specialist Program (In-Person Modality)
CSSP-V: Cloud & Security Specialist Program (Live Virtual Modality)
FSCP-I: Full Stack Coding Program (In-Person Modality)
FSCP-V: Full Stack Coding Program (Live Virtual Modality)
Please note that Centriq will be closed on the following observed holidays: New Year’s Day, Memorial Day, Independence Day, Labor Day, Thanksgiving Day, the day following Thanksgiving Day, and Christmas Day.
Start Date
End Date
Day/Eve
Break Weeks
Track
Jan 15, 2024
Apr 19, 2024
Day
2/19/24-2/23/24
3/18/24-3/22/24
CSSP-I
Feb 26, 2024
May 24, 2024
Day
4/1/24-4/5/24
CSSP-I
Apr 08, 2024
Jul 12, 2024
Day
5/27/24-5/31/24
7/1/24-7/5/24
CSSP-I
May 20, 2024
Aug 23, 2024
Day
5/27/24-5/31/24
7/1/24-7/5/24
CSSP-I
Jun 24, 2024
Sep 27, 2024
Day
7/1/24-7/5/24
9/2/24-9/6/24
CSSP-I
Jul 29, 2024
Feb 6, 2025
Eve
9/2/24-9/5/24
11/25/24-11/28/24
12/23/24-12/27/24
12/30/24-1/3/25
CSSP-I
Aug 5, 2024
Nov 8, 2024
Day
9/2/24-9/6/24
10/7/24-10/11/24
CSSP-I
Sep 9, 2024
Dec 13, 2024
Day
10/14/24-10/18/24
11/25/24-11/29/24
CSSP-I
Oct 21, 2024
Jan 31, 2025
Day
11/25/24-11/29/24
12/23/24-12/27/24
12/30/24-1/3/25
CSSP-I
Dec 2, 2024
Mar 14, 2025
Day
12/23/24-12/27/24
12/30/24-1/3/25
2/10/25-2/14/25
CSSP-I
If you don't see the Cohort Start date you are looking for don't forget to check out our online instructor-led calendar.
CSSP-I: Cloud & Security Specialist Program (In-Person Modality)
CSSP-V: Cloud & Security Specialist Program (Live Virtual Modality)
FSCP-I: Full Stack Coding Program (In-Person Modality)
FSCP-V: Full Stack Coding Program (Live Virtual Modality)
Please note that Centriq will be closed on the following observed holidays: New Year’s Day, Memorial Day, Independence Day, Labor Day, Thanksgiving Day, the day following Thanksgiving Day, and Christmas Day.