Install Report Builder
Applies to: ✔️ SQL Server 2016 Reporting Services and later ✔️ Power BI Report Server
Report Builder is a stand-alone app, installed on your computer by you or an administrator. You can install it from the Microsoft Download Center, from a SQL Server 2016 Reporting Services or later (SSRS) report server, or from a SharePoint site integrated with Reporting Services.
Looking for installation information for Power BI Report Builder instead? Head to the Microsoft Power BI Report Builder page on the Download Center.
An administrator typically installs and configures Reporting Services, grants permission to download Report Builder from the web portal, and manages folders and permissions to reports and shared datasets saved to the report server. For more information about Reporting Services administration, see Reporting Services Report Server (Native Mode).
Install Report Builder from a web portal or SharePoint library
Reporting Services integration with SharePoint is no longer available after SQL Server 2016.
You can start Report Builder from a Reporting Services web portal or a SharePoint site integrated with Reporting Services. For information, see Start Report Builder.
SharePoint site integrated with Reporting Services
On a SharePoint site integrated with Reporting Services, if the New Document menu does not list Report Builder Report, Report Builder Model, and Report Data Source, their content types need to be added to the SharePoint library. For more information, see Add Reporting Services Content Types to a SharePoint Library.
Install Report Builder with Microsoft Endpoint Configuration Manager
An administrator can also use software such as Microsoft Endpoint Configuration Manager to push the program to your computer. To learn how to use specific software to install Report Builder, consult the documentation for the software. For more information, see Microsoft Endpoint Configuration Manager documentation.
Windows Vista and Windows 7 security features require elevated permissions to run command line operations and will prompt for permission to run the command line. The installation is not silent. To make the installation silent, you need to run the command line as an administrator.
See the System Requirements section of the Report Builder download page on the Microsoft Download Center.
To install Report Builder from the download site
On the Report Builder page of the Microsoft Download Center , click Download.
After Report Builder has finished downloading, click Run.
This launches the SQL Server Report Builder Wizard.
Accept the terms in the license agreement and click Next.
On the Default Target Server page, optionally provide the URL to the target report server if it is different from the default. Click Next.
If you plan to work with Report Builder when it is connected to a report server, it is convenient to provide the URL to the server at this time. You can also do this from the Options dialog box in Report Builder.
Click Install to complete the installation of Report Builder.
To install Report Builder from a share
Contact your administrator for the location of ReportBuilder.msi that you run to install Report Builder on your local computer.
Browse to locate ReportBuilder.msi, the Windows Installer Package (MSI) for Report Builder, and click it.
This launches the SQL Server Report Builder Wizard.
Complete rest of the steps in To install Report Builder from the download site.
To install Report Builder from the command line
You can also perform a command line installation of Report Builder and provide arguments to customize the installation. In addition to the standard MSI intrinsic parameters, you can use the custom parameters that Report Builder provides: RBINSTALLDIR and RBSERVERURL. RBINSTALLDIR specifies the root installation folder for Report Builder. RBSERVERURL specifies the default report server that Report Builder uses to save reports on the server.
If you want a completely silent installation, with no user interface interaction at all, specify the /quiet option. By design, the quiet option flag suppresses installation errors. It is therefore recommended that you include the /l option, which specifies logging, when you use the quiet option.
On the Report Builder page of the Microsoft Download Center, click Download.
After Report Builder has finished downloading, click Save.
On the Start menu, click Run.
In the Open box, type cmd.
In the Command Prompt window, navigate to the folder where you saved ReportBuilder.msi.
Type a command with the following format:
msiexec /i ReportBuilder.msi OPTION=OptionValue [OPTION=OptionValue]
The two options specific to installing Report Builder are: RBINSTALLDIR and RBSERVERURL. You don't have to include these arguments in the command line. The following is the baseline command:
msiexec /i ReportBuilder3_x86.msi /quiet
To run the command, press ENTER.
Set Report Builder defaults
After you install Report Builder, you can set some default options. Click File > Options.
Setting the default Reporting Services web portal or SharePoint site is the most useful. For more information, see Set default options for Report Builder.
Click Report Builder .
If you don't see the report server in the list of existing servers, close the Open Report dialog box and then click Connect at the bottom of Report Builder to connect to the server.