Resolved | Microsoft Dynamics AX report preview error

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

VS1

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.

If this post helped you, please Like or comment.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: