SharePoint 2013 PerformancePoint Database Dropdown Empty

When configuring PerformancePoint Services in SharePoint 2013, I struggled for a while with two problems when trying to create a Data Source for in the PerformancePoint Dashboard Designer:

  • No matter what server name I entered I didn’t get an error.
  • The database dropdown was always empty, irrespective of whatever server name was entered.

After many hours effort, recreating the PerformancePoint Service Application several times, I finally stumbled across this blog entry .  This seemed to tally exactly with what I was encountering, though I didn’t spot the exception in the ULS logs, but at this point I was happy to try anything.  The solution appeared to be to install the ADOMD.NET 10.0 on the SharePoint Server which is running PerformancePoint Services.  I did this but had to do the additional step of running an IISRESET in order to get the change to kick in properly and sure enough after this I managed to connect successfully to the Analysis Services cubes.

Hope this helps and thanks to James Love for this invaluable nugget …

Cheers

Dave Mc

 

Advertisements

About davemcmahon81
Software Developer & Architect, User Group Leader, Speaker, Writer, Blogger, Occasional Guitarist, Man-made Global Warming Sceptic, Climate Change Believer, General Optimist but most of all proud Husband and Dad ...

One Response to SharePoint 2013 PerformancePoint Database Dropdown Empty

  1. devinknight says:

    Thanks! Ran into the same thing today.

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: