question

AndyMay-3799 avatar image
1 Vote"
AndyMay-3799 asked ·

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

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-servicessql-server-analysis-servicesvs-extensions
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered ·

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

· 5 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi

Very interesting, so as a Microsoft Employee you are saying that as a BI development tool, Visual Studio 2019 is not fit for purpose?

Regards

1 Vote 1 ·

No, I am suggesting using previous SSDT like Visual Studio 2019 - 16.8.2 (Although it is not the cause for the issue, but this version is currently more stable). And previous Version 3.11 SSIS in my second link.

The SSAS team and SSIS team are working on this issue and have had couple release. But I would suggest to use previous version first to solve our currently problem. And wait for the final release of this bug fixing.



0 Votes 0 ·

Thankyou for your response, I will install an earlier version, and try that.

I get a bit frustrated with SSDT, it make Visual Studio unstable, and has done for a long time, I have worked with BI development on the Microsoft ss platform for a long time, since before 2005 and the initial launch of SSIS and it seems that it is never a stable solution. in the field I work in, I have no real alternative but to work with it, so it is something that I am always hoping for better stability, and it never comes

1 Vote 1 ·
Show more comments
TomDeCort-3416 avatar image
0 Votes"
TomDeCort-3416 answered ·

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

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TomDeCort-3416 avatar image
0 Votes"
TomDeCort-3416 answered ·

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

· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Glad it works again!
Thanks for sharing ! :)

0 Votes 0 ·