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

Question

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

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.

score 5 · Accepted Answer · edited May 23 '17 at 10:29

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" .

And if you're running SQL Server 2014 try `newVersion="12.0.0.0"`. — Kendall Lister, Jan 19 '17 at 23:24

score 1 · Answer 2 · answered Oct 06 '15 at 19:24

In my case this was the source of the problem:

The PerformancePoint Services Unattended Service Account is not set. The setting is located in "Manage service applications" in SharePoint Central Administration under the PerformancePoint Services management page.

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

2 Answers2