Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server - Windows only
SQL Server features that are part of the Microsoft Business Intelligence platform include Analysis Services, Integration Services, Master Data Services, Reporting Services, and several client applications used for creating or working with analytical data. This section of the SQL Server Setup documentation explains how to install these features.
Analysis Services and Reporting Services can be installed as standalone servers, in scale-out configurations, or as shared service applications in a SharePoint farm. Installing the services in a farm enables BI features that are only available in SharePoint, including Power Pivot for SharePoint and Power View, the Reporting Services ad hoc interactive report designer that runs on Power Pivot or Analysis Services tabular model databases.
Note
Reporting Services integration with SharePoint is no longer available after SQL Server 2016. Power View support is no longer available after SQL Server 2017.
All SQL Server features, including the BI components, are installed through SQL Server Setup. The following links provide supplemental information specific to each BI feature.
Note
SQL Server Data Tools (SSDT) is not included with SQL Server 2016. Download SQL Server Data Tools.
What's New in Reporting Services (SSRS)
What's New in Analysis Services
What's New in Integration Services
What's New in Master Data Services (MDS)
Install SQL Server
Upgrade to SQL Server
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Describe the capabilities of Microsoft Power BI - Training
In this module, learners are introduced to Microsoft Power BI and its rich data analytics and data visualization capabilities.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.
Documentation
Install SQL Server Integration Services - SQL Server Integration Services (SSIS)
Learn how to install Microsoft SQL Server Integration Services (SSIS) and how to get other downloads for SSIS.
Install SQL Server Data Tools (SSDT) - SQL Server Data Tools (SSDT)
Learn about SQL Server Data Tools (SSDT). See how to install this database development tool set with Visual Studio 2019 and 2022.
SSIS Projects extension for VS2022 troubleshooting guide - SQL Server Data Tools (SSDT)
SSIS Projects extension for VS2022 troubleshooting guide