SQL Server 2012 – How To change a Analysis Service Instance Type 2
Posted by Diego em Junho 5, 2013
This is a FYI regarding this post where I was talking about changing a SSAS instance from multidimensional to tabular.
If you do that and try to create a SSAS Tabular project on SSDT with that SSAS instance as the “default workspace server” you will get this error the moment you click the .bim file:
This file cannot be opened. You can only open files that are compatible with Microsoft SQL Server 2012.
An error occurred while opening the model on the workspace database. Reason: This file cannot be opened. You can only open files that are compatible with Microsoft SQL Server 2012.
So yeah, even though you can change a SSAS instance from multidimensional to tabular, I wouldn’t do that. In my case, I had to uninstall the multidimensional one that I changed to tabular and install a new tabular one