I'm just back from the European SharePoint Conference 2014 in Barcelona. Lots of great sessions, and I delivered a brand new class on Access Services and Power BI. (A lot more tips and tricks coming from that one!)
Barcelona Magic © 2014 Christopher F. McNulty and on Flickr
I recently rebuilt one of my demo systems and was having difficulty finding my SQL Analysis Services cubes in Dashboard Designer. If you saw my previous post last year (Why can't SharePoint Dashboard Designer 2013 connect to SQL Analysis Services 2012?) many of this issues can be solved by installing the previous version of ADOMD.NET library support on the system running Dashboard Designer. Dashboard Designer in SharePoint 2013 uses the library support from SQL 2008 R2; SharePoint 2010 uses SQL 2008 – its always one rev behind. But I was still having issues even after this fix.
There's another related technique that can be used in web.config to redirect the calls for the old library to the current one – which may be a better answer. Find web.config on the path:
\Program Files\Microsoft Office Servers\15.0\WebServices\PpsMonitoringServer
Inside web.config you need to find the lines that read:
publicKeyToken="89845dcd8080cc91" culture="neutral" />
<bindingRedirect oldVersion="18.104.22.168" newVersion="10.0.0.0" />
Inside the bindingredirect key, change the line from:
And you should be all set! This change allows SharePoint 2013 to use the SQL 2012 ADOMD.11 libraries; the original line substitutes the ADOMD 10 libraries is version 9 is called.