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,239 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. Lukas Yu -MSFT 5,816 Reputation points
    2021-01-27T08:30:13.907+00:00

    Hi,

    Thanks you for your post here, @Ed Patino anonymous user @Matt Benham .

    May I ask what is your operating system ? I just test with a new environment with :

    VS - 16.8.4
    AS Project - 2.9.15
    OS - Window Server 2019

    And I have not met such issue in Tabular model.

    Did your VS work correctly at old version ? If your need is urgent , I suggest you to work with old build first and wait for the hot fix on this issue. You could download older version of VS at Download Visual Studio. As I used 16.8.2 for a long time and never met such issue.

    Regards,

    Lukas


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    What can I do if my transaction log is full?--- Hot issues November
    How to convert Profiler trace into a SQL Server table -- Hot issues November

    1 person found this answer helpful.

  2. NRond 1 Reputation point
    2021-01-27T14:35:42.84+00:00

    Hi all,

    I ran into the same problem,
    and as I knew I installed an update of SQL Server Integration Services Projects earlier, I tried uninstalling this version 3.12 and reinstalling version 3.11.1
    The error no longer appears with this.
    You can download the old version of SSIS projects here: SSIS Project

    0 comments No comments

  3. RoschinMU 1 Reputation point
    2021-01-29T12:44:44.817+00:00

    У меня установлены SSIS и SSAS, была ошибка и я просто отключил SSIS и модель стала открываться.

    0 comments No comments

  4. Lasater, John 1 Reputation point
    2021-02-09T16:45:01.047+00:00

    It appears that disabling the SSIS extension also works. It's not as convenient but can be a quick workaround.

    0 comments No comments