Omicron Llama

Coding all day, every day.

Connecting to Analysis Services on SQL Server 2012 from PerformancePoint on SharePoint 2013 Preview

You might notice in PerformancePoint Dashboard Designer that when you create an Analysis Services Data Source, typing in a server name throws no error but the Database dropdown box never populates.

Look to the event logs and you might find this error shown shortly after loading Dashboard Designer:

Unable to load custom data source provider type: Microsoft.PerformancePoint.Scorecards.DataSourceProviders.AdomdDataSourceProvider, Microsoft.PerformancePoint.Scorecards.DataSourceProviders.Standard, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c


System.IO.FileNotFoundException: Could not load file or assembly ‘Microsoft.AnalysisServices.AdomdClient, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The system cannot find the file specified.
File name: ‘Microsoft.AnalysisServices.AdomdClient, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’
   at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMarkHandle stackMark, IntPtr pPrivHostBinder, Boolean loadTypeFromPartialName, ObjectHandleOnStack type)
   at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean loadTypeFromPartialName)
   at System.Type.GetType(String typeName, Boolean throwOnError)
   at Microsoft.PerformancePoint.Scorecards.Server.PmServer.InitializeCustomDataSourceProviders()






PerformancePoint Services error code 10107.

As you can see, PerformancePoint here isn’t using ADOMD.NET 11, the SQL Server 2012 version.

You need to find the version 10 of ADOMD.NET installer which comes with the SQL Server 2008 R2 Feature Pack from the Microsoft Download Centre. Install this, perform an IIS Reset then open PeformancePoint again to see the Data Source editor working fine once again.

Direct Link for ADOMD.NET10 for x64

Microsoft Download Centre page for SQL Server 2008 R2 Feature Pack

17 thoughts on “Connecting to Analysis Services on SQL Server 2012 from PerformancePoint on SharePoint 2013 Preview

Leave a Reply

Your email address will not be published. Required fields are marked *