Why Dashboard Designer In SharePoint 2013 Can Not Load SSAS Database For Create New SSAS Datasource?

Ardalan Shahgholi picture Ardalan Shahgholi · Feb 5, 2014 · Viewed 7.2k times · Source

I use SharePoint 2013 and SQL Server 2012 SP1 Update 8

I Config Performance Point Service and Excel Service and .... in my Share Point.

When I want create a new SSAS DataSource in Performance Point, List of SSAS Database is empty!

I install SharePoint and SQL Server 2012 SP1 in the same server.

I Can connect to my SSAS in Multidimensional Mode.

enter image description here :

this is properties of my Multidimensional Database

enter image description here

This Configuration of SSS In SharePoint

enter image description here

enter image description here

enter image description here

enter image description here

This is configuration of Performance Point Service :

enter image description here

And finally when I want create a new Data Source in Dashboard Designer , list of database of ssas is empty?!?

enter image description here

I see this link Cannot create SSAS Data Source in PPS Dashboard Designer and then i verify and install ADOMD in my server and restart my server but until it not work.?!?

Note : I run Power Pivot Service and Excel Services in my Sharepoint and those services work.

Answer

Ardalan Shahgholi picture Ardalan Shahgholi · Feb 5, 2014

I fond my problem and fix it .

This is source of answer : Database doesn't show when creating a data source for Performance Point Dashboard Designer

As Krishna N say :

I fix it with edit Web.config in this path

\Program Files\Microsoft Office Servers\15.0\WebServices\PpsMonitoringServer

and in below block :

 <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="Microsoft.AnalysisServices.AdomdClient" 
            publicKeyToken="89845dcd8080cc91" culture="neutral" />
        <bindingRedirect oldVersion="9.0.0.0" newVersion="10.0.0.0" />
      </dependentAssembly>
    </assemblyBinding>
</runtime>

I change oldVersion="9.0.0.0" newVersion="10.0.0.0" to oldVersion="10.0.0.0" newVersion="11.0.0.0" .