Method not found: 'Microsoft.AnalysisService.Database Microsoft.AnalysisSerices.JsonSerializer.DeserializeDatabese

Ed Patino 36 Reputation points
2021-01-26T15:25:39.54+00:00

I am working on Visual Studio 19 Pro and have been unable to open any of my Tabular model projects. I have checked that extensions are installed have rolled back the versions and uninstalled/reinstalled and I continue to get the following:

Error Cannot build obj\Development\Model.asdatabase. Reason: Method not found: 'Microsoft.AnalysisServices.Database Microsoft.AnalysisServices.JsonSerializer.DeserializeDatabase(System.String, Microsoft.AnalysisServices.Tabular.DeserializeOptions, Microsoft.AnalysisServices.CompatibilityMode)'.

And

Method not found: 'Microsoft.AnalysisServices.Tabular.Model
Microsoft.AnalysisServices.Database.get_Model()'

I am on VS19 Version 16.8.4
Microsoft Analysis Services Project V 2.9.14
I am able to open SSIS projects and SSRS project with no issue.

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,244 questions
{count} votes

Accepted answer
  1. DorelAdam-1134 126 Reputation points
    2021-01-27T13:34:46.873+00:00

    OK guys,

    The error seems to come from the SQL Server Integration Services Projects extension version 3.12 released on January 25. I uninstalled it and I was able to open the tabular project and build it.

    I reverted back to version 3.11.1 from December 28 and everything is fine now.

    https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects

    10 people found this answer helpful.

8 additional answers

Sort by: Most helpful
  1. Matthew Chapman 1 Reputation point
    2021-12-08T16:29:34.763+00:00

    Well I got caught in this tap and the old version of SSIS 3.11 doesn't seem to be available via the links supplied. Where might I find this older version. Or maybe there is a different fix now?

    0 comments No comments

  2. DorelAdam-1134 126 Reputation points
    2021-12-08T16:32:36.46+00:00
    0 comments No comments

  3. Matthew Chapman 1 Reputation point
    2021-12-08T17:36:27.797+00:00

    I tried it and getting the same error: Method not found: 'Microsoft.AnalysisServices.Tabular.Model Microsoft.AnalysisServices.Database.get_Model()

    0 comments No comments

  4. Matthew Chapman 1 Reputation point
    2021-12-08T19:07:32.507+00:00

    Ok I uninstalled and re-installed SSDT then installed SSAS Projects then updated updated that to SSAS Projects 2.9.18. Then I reinstalled SSIS Projects 3.15. This missing piece was that I hadn't updated SSAS.

    0 comments No comments