Most of my blog posts on which I confronted in my daily routine job. Our development team has reported an error they are getting an error screen while preview the SSRS reports from visual studio 2013. Error: Unable to preview the report, install the Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2013.
AX Version: AX2012R3CU10
SQL Server: SQL Server 2014
Visual Studio: Visual Studio 2013
I understood that this error due to the missing installation of SQL Server data tool component on the server. When we try to run SQL Server 2014 setup file, SQL Server data tools component doesn’t present. One of TechNet blog says Microsoft has removed SQL Server data tools component from SQL Server 2014 Setup/ISO. Alternatively, Microsoft has released a separate setup file with this component “Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2013”.
After installing SSDTBI component on my SQL Server, reports preview issue stands resolved. You can download SQL server data tools from below link.Download Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2013
Note: If you encounter same error with AX 2012, SQL Server 2012 and Visual Studio 2010, Install the SQL Server data tools from SQL Server 2012 Setup file.