SSAS Database Doesn’t Show Up in SharePoint 2013 Dashboard Designer

Posted in: Technical Track

Howdy everyone,

Just a quick tip for everyone that is struggling to configure SharePoint Server 2013 PerformancePoint  to connect to a SQL Analysis Services 2012 or 2014 cube.

After a new SharePoint Server 2013 installation, I have tried to create a new connection to my Analysis Services cube through the SharePoint Dashboard Designer, but no matter what, the Database option always shows up as empty and I can select my Analysis Services database.

DashboardDesigner

 

In the Windows server log event I could find the following message:

The data source provider for data sources of type ‘ADOMD.NET’ is not registered. Please contact an administrator.

PerformancePoint Services error code 10115.

The reason you would receive this error message, believe it or not, is because even if you are using SQL Server 2012 or newer, and SharePoint Server 2013, it will try to load the SQL Server 2008 version of the ADMD.NET dll.

If you install the SQL Server 2008 R2 ADMD.NET component, that you can download from the following location: http://www.microsoft.com/en-us/download/details.aspx?id=16978 , and restart IIS you will fix this issue and will be able to successfully connect to your SQL Server 2012/2014 Analysis Services database.

Hope this helps.

 

Interested in working with Felipe? Schedule a tech call.

About the Author

A self-proclaimed geek, Felipe admits his curiosity gets him in trouble because he often finds himself “working” on weekends. A lover of data, research, and studying, he has learned a lot of what he knows by teaching himself so he can form a truly unbiased perspective. Felipe’s clients and peers can rely on him for just about any issue related to data warehousing and business intelligence. Addicted to adrenaline, Felipe can be found skydiving and bungee jumping in his spare time.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *