February 2, 2016

Unable to preview the report, install the Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2013

When I tried to preview AX report in Visual studio 2013, received above error.

My environment details are:
Operating System: Windows server2012R2
Application: MSD AX2012R3CU10
SQL Edition: SQL2014SP1 Developer Edition
Visual Studio: VS2013 Professional with Update 4

As per the TechNet / blogs, In SQL 2014, Business intelligence feature is removed. Previous versions of SQL 2014 (ex: SQL2012SP1) Business intelligence feature is available with name ‘SQL Server Data Tools’ and it comes with SQL media file.
To resolve Reports preview issue we have to download and Install Business intelligence tools in your host alone.

---------------------------- Same post I re blogged on my other blog--------------------------
                                       "Yours Ravi Theja Madisetty"