Analysis Services - Deserialization Failed: 'AllowedRowsExpression' Element in Namespace

Views: 120
Reading Time: 2 minutes

Hello people,
Good afternoon.

In this post I will explain a very common error for BI analysts using SQL Server 2008 and after migrating to SQL Server 2012 and 2014 come across the error message below when trying to open Visual Studio 2008 (BIDS)

Deserialization failed: The 'AllowedRowsExpression' element in namespace 'http://schemas.microsoft.com/analysisservices/2011/engine/300/300' is unexpected. (Microsoft Visual Studio)

Microsoft Analysis Services - Error AllowedRowsExpression in Namespace

This error occurs because of a major change in the structure and organization of XML used by Analysis Services from the 2012 version of SQL Server. To solve this situation, we have two solutions:

Using SQL Server 2012 Feature Pack

One way to solve this problem is by using SQL Server 2012 Feature Pack. To do this, go to the link of SQL Server 2012 Feature Pack, download and install (in order) the items:

  • SQL_AS_OLEDB.msi
  • SQL_AS_ADOMD.msi
  • SQL_AS_AMO.msi

If you get an error message like “A network error occurred while trying to read from the file ..”, this feature is already installed.

Using SQL Server Data Tools for Visual Studio 2013

Another alternative is to use the SQL Server Data Tools for Visual Studio, which is the successor to Business Intelligence Development Studio (BIDS) and compatible with the more complete, robust and redesigned Analysis Services 2012, 2014, and 2016 cubes.

I believe this is the best and most practical option as we have to keep our work tools up to date and keeping up with the market and new technologies rather than looking for ways and continuing to use outdated and outdated tools.

Any questions, leave your questions in the comments I will answer.
Hug!