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

Andy May 56 Reputation points
2021-02-08T02:44:25.867+00:00

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

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,857 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,006 questions
No comments
1 vote

Accepted answer
  1. Lukas Yu -MSFT 5,796 Reputation points
    2021-02-08T09:00:05.99+00:00

    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


2 additional answers

Sort by: Most helpful
  1. Tom De Cort 1 Reputation point
    2021-03-05T16:00:35.647+00:00

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

    No comments

  2. Tom De Cort 1 Reputation point
    2021-03-18T13:53:57.83+00:00

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