Skip to content
July 9, 2014 / Rodrigo Chiolas

Dashboard Designer 2013 – Cannot load database for new SSAS datasource

Problem

At dashboard designer,  when trying to create a SSAS datasource, the step to select a database, only shows “Loading..”, and you cant select a database.

Solution

On SQL Server you need to install SQL Server xxxx ADOMD.NET, where xxxx is the version of sql server, e.g., 2008, 2012.

You can try now, but it is probably that you still see an error.

For some reason, version installed and version configured it is usually different, so you probably need to edit the config file.

Go to the path (or equivalent):

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

In the Web.config file:

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

This code is just changed to:

<runtime>

<assemblyBinding xmlns=”urn:schemas-microsoft-com:asm.v1″>

<dependentAssembly>

<assemblyIdentity name=”Microsoft.AnalysisServices.AdomdClient” publicKeyToken=”89845dcd8080cc91″ culture=”neutral” />

<bindingRedirect oldVersion=”10.0.0.0″ newVersion=”11.0.0.0″ />

</dependentAssembly>

</assemblyBinding>

</runtime>

An it should solve your problem.

Ref: http://www.c-sharpcorner.com/UploadFile/a9d961/create-an-analysis-service-data-source-connection-using-shar/

 

Advertisements

2 Comments

Leave a Comment
  1. dota 2 treasure key generator 2014 / Jul 27 2015 4:13 pm

    Hello Your main site loads up really slow for me, I don’t know who’s problem is
    that however , flickr starts extremely immediate. Nevertheless,
    Thanks for putting up an extraordinarily excellent blog post.
    I think this has been incredibly helpful to user who seem to
    visit here. I hope I’ll be able to get even more amazing information and I should flatter your site by stating you have carried
    out wonderful job. Right after checking out the article, I have
    book marked the website.

  2. Margareta / Nov 27 2015 6:30 pm

    Hey Facebook performs perfectly to me but your site is loading steadily which had taken about a few minutes
    to successfully load up, I’m not sure whether or
    not it’s my very own issue or maybe website issue. On the other
    hand thank you for writing beautiful article. Everyone who actually visited this site must have observed this short article honestly helpful.
    This is fantastic everything that you actually have concluded in this article and want to discover even more posts from you.
    I now have you saved to bookmarks to check out new stuff you post.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: