Visual Studio 2015
BI Developer Extensions for Visual Studio 2015 is published in the Visual Studio Marketplace. To install it, go to Tools… Extensions and Updates… go to the Online tab and then search for BI Developer Extensions:
You can also download it from the Visual Studio Marketplace in a web browser here.
Visual Studio 2017
BI Developer Extensions for Visual Studio 2017 is published in the Visual Studio Marketplace. To install it, go to Tools… Extensions and Updates… go to the Online tab and then search for BI Developer Extensions:
You can also download it from the Visual Studio Marketplace in a web browser here.
Ensure you have the latest version of SSDT installed for Visual Studio 2017. Reference the table below for the targeted SSAS/SSRS/SSIS extension versions. Then in Visual Studio 2017 go to Tools… Extensions and Updates… Updates tab… then ensure you install any updates to Microsoft Analysis Services Projects, Microsoft Reporting Services Projects, or Microsoft Integration Services Projects.
If in Tools… Options… BIDS Helper… Version the SSDTBI Build version isn’t at or greater than the SSDTBI Build listed in the table below, you may need to uninstall all SSAS, SSRS, and SSIS extensions then reinstall them. This procedure should update the underlying shared modules.
Visual Studio 2019
BI Developer Extensions for Visual Studio 2019 is published in the Visual Studio Marketplace. To install it, go to Extensions… Manage Extensions… go to the Online tab and then search for BI Developer Extensions:
You can also download it from the Visual Studio Marketplace in a web browser here.
Ensure you have the latest version of SSDT installed. In Visual Studio 2019 go to Extensions… Manage Extensions… Online tab… then search for BI Developer Extensions. Reference the table below for the targeted SSAS/SSRS/SSIS extension versions.
If in Tools… Options… BIDS Helper… Version the SSDTBI Build version isn’t at or greater than the SSDTBI Build listed in the table below, you may need to uninstall all SSAS, SSRS, and SSIS extensions then reinstall them. This procedure should update the underlying shared modules.
Older Versions
For SQL 2005 (Visual Studio 2005), SQL 2008 (Visual Studio 2008), SQL 2008 R2 (Visual Studio 2008), download release 1.7.0.
For SQL 2012 (Visual Studio 2010 and Visual Studio 2012) and SQL 2014 (Visual Studio 2013), though release 1.7.0 works, we recommend moving development to Visual Studio 2017 which is backwards compatible with SQL 2012 and SQL 2014. For Visual Studio 2017, install BI Developer Extensions from the Visual Studio gallery using the instructions above.
To install BI Developer Extensions in Visual Studio 2005-2013, download the installer mentioned above. For silent installs you can run the setup .exe file with a /S command line option.
If for some reason you cannot use the installer the latest release includes an xcopy deploy option.
Versions Summary
The following versions of SSDT and BI Developer Extensions are compatible with each other. The bolded lines (Visual Studio 2017 and 2019) are still being maintained.
| Visual Studio Version | SQL Versions | SSDT Installer Version | SSDTBI Build | SSAS Extension Versions | SSIS Extension Versions | SSRS Extension Versions | BI Developer Extensions Version |
|---|---|---|---|---|---|---|---|
| 2019 | 2012-2022 | N/A | 16.0.19836.0 | 2.9.18 | 4.4 | 2.6.11 | 2.4.1 |
| 2019 | 2012-2019 | N/A | 15.0.19126.0 | 2.9.12 | 3.9-3.16 | 2.6.7 | 2.4.0 |
| 2019 | 2012-2019 | N/A | 2.9.12 (or higher) |
3.8 | 2.6.7 | 2.3.9 | |
| 2019 | 2012-2019 | N/A | 2.9.10 (or higher) |
3.7 | 2.6.7 | 2.3.8 | |
| 2019 | 2012-2019 | N/A | 2.9.8 | 3.5 | 2.6.5 | 2.3.7 | |
| 2019 | 2012-2019 | N/A | 2.9.6 | 3.5 | 2.6.3 | 2.3.5 | |
| 2019 | 2012-2019 | N/A | 2.8.15 - 2.8.17 | 3.1 | 2.5.9 | 2.3.4 | |
| 2019 | 2012-2019 | N/A | 2.8.14 | 3.0 | 2.5.7 | 2.3.3 | |
| 2017 | 2012-2019 | 15.9.6 | 15.0.1659.0 | 2.9.12 (or higher) |
2.7 | 2.6.7 | 2.4.0 |
| 2017 | 2012-2019 | 15.9.5 | 2.9.12 (or higher) |
2.4 | 2.6.7 | 2.3.9 | |
| 2017 | 2012-2019 | 15.9.5 | 2.9.10 (or higher) |
2.4 | 2.6.7 | 2.3.8 | |
| 2017 | 2012-2019 | 15.9.4 | 2.9.8 | 2.4 | 2.6.5 | 2.3.7 | |
| 2017 | 2012-2019 | 15.9.3 | 2.9.6 | 2.4 | 2.6.3 | 2.3.5 | |
| 2017 | 2012-2019 | 15.9.2 | 2.8.15 - 2.8.17 | 2.1 - 2.4 | 2.5.9 | 2.3.4 | |
| 2017 | 2012-2019 | 15.9.0 - 15.9.1 | 2.8.11 - 2.8.14 | 2.1 - 2.3 | 2.5.6 - 2.5.7 | 2.3.3 | |
| 2017 | 2012-2019 | 15.8.2 (or older) |
2.0 | 2.1 | 2.0 | 2.2.1 | |
| 2015 | 2012-2017 | 17.4 | 2.1.1 | ||||
| 2013 | 2014 | 12.0.2430 | 1.7.0 | ||||
| 2012 | 2012 | 11.0.5583 | 1.7.0 | ||||
| 2010 | 2012 | 1.7.0 | |||||
| 2008 | 2008-2008R2 | 1.7.0 | |||||
| 2005 | 2005 | 1.7.0 |