How to Install MSBI – SSIS, Analysis & Reporting Services using Microsoft Visual Studio

How to Install Microsoft Business Intelligence – SSIS SSAS SSRS using Visual Studio Latest Version

If you want to install Microsoft Business Intelligence (MSBI ) – SSIS , Analysis Services & Reporting Services using latest version of Visual Studio ( at the time of writing blog ) , the first thing that you need to do is to Download Visual Studio . You can either search on Google for Microsoft Visual Studio 2019 Community or directly download from the below link

For people who already have a license to Visual Studio 2019:

1. For SQL Database Projects, install the Data storage and Processing workload for Visual Studio
2. For Analysis Services, Integration Services or Reporting Services projects, install the appropriate extension(s) from the marketplace

To get in depth knowledge on Microsoft business intelligence, enrich your skills on Msbi online training

professionals

For people who don’t have a Visual Studio 2019:

1. Install Visual Studio
2. Install the Analysis Services, Integration Services or Reporting Services extension as appropriate

We will explore the steps for people who don’t have a Visual Studio licence in detail below so that we don’t face any problem

Installation of Visual Studio 2019 and SQL Server Data Tools before adding Extension SSIS ,Analysis Services & Reporting Services

Once you reach this page, Click & Download the Community Edition

It will take a while to Download . Once the download Completes you will be able to see the below screen . You can install a large number of things from below based on your development requirements . For Msbi SSIS , SSAS , SSRS we need to install the Sql Server Data Tools . Select as below and click on install

Once the installation completes the below screen opens up . But you will not have SSIS , SSAS , SSRS right now . You will need to get it from extension.

Now in order to install SSIS , you will need to get it from “Extension” as below .

To Install SSIS – Microsoft Sql Server Integration Services Extension,

Click on “Extensions” from the toolbar, Click on Online on the Left-Hand side and the Search for Microsoft Reporting Services

It will be downloaded as an exe . Double click to install . Before Installing , Close your Visual Studio as we are trying to make changes to it while open so we will receive error .

In the next Step you have to choose the Visual Studio where you want to install SSIS (see screen below). If you have your Visual Studio still open, you will get error after this step as you have not closed Visual Studio and trying to make changes to it.

Once you click on Install and give permission, the SSIS will start getting installed.

Once the installation completes you will see the below confirmation.

Installation of SSAS & SSRS Microsoft Analysis & Reporting Services Extension

To Install Microsoft Analysis & Reporting Services Extension , click on “Extensions” from the toolbar , Click on Online on the Left Hand side and then Search for Microsoft Analysis & Reporting Services. This will start Downloading in the Application itself . Once the Download is complete Restart the Visual Studio

Once you restart Visual Studio , the installation of these will start happening and you will get the below window.

Click on Modify and the installation will start. It takes some time , so please be patient. Once the installation is complete , you will get the below confirmation

To get a dept knowledge on Msbi, learn more through with professionals Msbi online training Hyderabad