When I tried to create a new report with Reporting Service template via PerformancePoint Dashboard Designer.
I got the following error
Failed to load the appropriate report editor
You seem to be missing Microsoft Report Viewer 2012, which you need in order to create Reporting Services reports in Dashboard Designer.
First, make sure that Microsoft System CLR Types for SQL Server 2012 has been installed before installing Microsoft Report Viewer 2012 to avoid the following error.
Setup is missing an installation prerequisite : Microsoft System CLR Types for SQL Server 2012
To download and install Microsoft system CLR Types for SQL Server 2012 check this link
- Click Download.
- Select Select \x64\SQLSysClrTypes.
- After installing Microsoft system CLR Types, go back to download and install Microsoft Report Viewer 2012
To download and install Microsoft Report Viewer 2012
- Download it from the following link
- Or click on the link within Information dialog that will download Microsoft Report Viewer 2012 automatically.
- Click run to install it.
Now close the PerformancePoint Dashboard designer and reopen it again that should be now working properly 🙂