Visual Studio 2019 attempting to develop for SSAS Method not found: 'Microsoft.AnalysisServices.Tabular.Model Microsoft.AnalysisServices.Database.get_Model()'.

Question

I use the BI tools extensions in VS 2019, being ssis ssas and ssrs. I recently upgraded my install of VS2019 p version 16.8.4, since then I can no longer open Analysis Services Tabular Model (SSAS) solutions in VS 2019, the solution opens but whenever I try to open a model I receive the following exception: Method not found: 'Microsoft.AnalysisServices.Tabular.Model Microsoft.AnalysisServices.Database.get_Model()'.

I did a quick bing search for a solution and found many references to SSIS, so I thought maybe the best thing was to try uninstalling VS and re-installing, the SSIS extension requires a separate install, whereas the other 2 install via the installer. So I installed SSAS and SSRS extensions, and was able to open my SSAS solutions fine, then I installed the SSIS extension and this got me back to the same exception. One small complication may be that I also use the full set of KingswaySoft SSIS extensions.

If I uninstall the SSIS visual studio extension then I can use ssas, but it seems problematic if I need to uninstall the SSIS extension when I need to do SSAS work

Any help would be much appreciated

Answer 1

Hi,

This is a known issue that has been reported.

If you want SSIS and SSAS project work in one machine, one choice is that you could down load previous version Visual Studio / SSDT and SSIS project.

You could use previous Visual Studio and SSIS

The SSIS site has also described this issue you could see it in above link.

Hope this helps.

Regards,
Lukas

Answer 2

Just lost half a day on this. Please fix this asap. I think the majority of "BI" developers use both extensions...

Answer 3

Thanks for fixing!
Install latest version of SSAS and SSIS extensions and everything will work again