Visual Studio 2019 support missing in BISM Normalizer

fmms commented 5 years ago

Hi,

i have moved to VS2019.

Analysis Services are supported (see https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftAnalysisServicesModelingProjects). However, BISM Normalizer (see https://marketplace.visualstudio.com/items?itemName=ChristianWade.BISMNormalizer3 ) is not available yet. Do you have any timeline? Without BISM normlizer a important piece is missing for me.

regards

shswindell42 commented 5 years ago

I've created a pull request #31 addressing this. I was able to install it into my instance of VS 2019 and it seems to be working without issue. Perhaps this will get pushed up to the marketplace.

Guavaq commented 5 years ago

Hi @shswindell42 how did you go about getting the pull request and get it working in VS 2019?

I am not sure how to do this, any advice would be appreciated.

shswindell42 commented 5 years ago

You should be able to pull my fork of this https://github.com/shswindell42/Analysis-Services/tree/BISMNormalizerVS2019, open the BismNormalizer.sln solution file (in VS 2019) and build it (You'll need to install the Visual Studio extension development package from the VS Installer). That should create a .vsix file that you can run to install the extension into VS 2019. The file will be created in the BismNormalizer\bin\Release folder.

After it's installed the Tabular Comparison Tool will be available under the Tools menu.

Guavaq commented 5 years ago

Thanks for the details.

I am no developer and for some reason it was complaining about the Bismnormalizer.TabularCompare namespace that it could not find.

Any idea's on what to do, or if I could get a copy of the VSIX?

christianwade commented 4 years ago

Thanks all for the responses and sorry for the delayed response. I plan to monitor this more closely in future! You're probably aware BISM Normalizer works with VS 2019 now

ashishegon commented 3 years ago

Thanks all for the responses and sorry for the delayed response. I plan to monitor this more closely in future! You're probably aware BISM Normalizer works with VS 2019 now

The BISM Normalizer is not working on VS 2019 version 16.6.5 with latest Analysis Services extension. Kindly help, its urgent.

christianwade commented 3 years ago

What's the problem you are experiencing? Is it the following error? Method not found: 'Microsoft.AnalysisServices.Tabular.Model Microsoft.AnalysisServices.Database.get_Model()'.

I have been unable to repro this. Apparently it may be caused by an SSDT bug with SSIS as some users reported that uninstalling the SSIS extension resolved it. Please let me know if you experience the same. If you want to send me the project files (assuming it repros locally without a connection to the server), I'm happy to try

JuanesPedro commented 3 years ago

What's the problem you are experiencing? Is it the following error? Method not found: 'Microsoft.AnalysisServices.Tabular.Model Microsoft.AnalysisServices.Database.get_Model()'.

I have been unable to repro this. Apparently it may be caused by an SSDT bug with SSIS as some users reported that uninstalling the SSIS extension resolved it. Please let me know if you experience the same. If you want to send me the project files (assuming it repros locally without a connection to the server), I'm happy to try

Hi Christian,

I'm getting this error as well.

configured a new laptop, installed VS2019 / SSIS / SSAS extensions en BISM.
imported Tabular project from Analysis Server 2016
did some changes
As soon as I hit the OK button after comparing the project with the database I get this error.

BISM Normalizer 5.4.4.2 Analysis Services Projects 2.9.12 Integration Services Projects 3.8 Studio 16.6.5

Disabling the Integration Services Projects resolves the problem like you said.

On my old laptop everything worked just fine, so I looked a bit deeper into the differences As it turned out: Integration Services Projects was version 3.7 Analysis Services Projects version 2.9.10

I upgraded Integration Services Projects to 3.8 and the same problem appeared. So this must be the issue.

ashishegon commented 3 years ago

it looks like SSIS/Integration update which caused the issue. Since i upgraded the VS, Analysis Services and Integration updates in the Visual Studio. To workaround, installed the VS 16.2, with no further updates, since the work was getting impacted. Hope this helps others and the issue is resolved for others. Thanks.

vmihay commented 3 years ago

For those searching for solution, I found two workarounds that work. I tried the first and it worked.

================================================================================

I had the same issue. Instead of uninstalling, i just disabled SSIS extension and it worked. Now whenever i have to use SSIS , i just need to re-enable SSIS before using. Its annoying but works quite well.

Originally posted by @pankajpandya in https://github.com/microsoft/Analysis-Services/issues/67#issuecomment-768916518

================================================================================

Its a known problem with the SSIS 3.12 install. Suggest you download SSIS 3.11.1

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

Originally posted by @MickealpDavis in https://github.com/microsoft/Analysis-Services/issues/67#issuecomment-772933182

AndrewBorst commented 3 years ago

Upgrading to SSIS 3.13 didn't fix the bug but disabling the extension, closing the Visual Studio, and re-opening is still a decent workaround.

microsoft / Analysis-Services

Visual Studio 2019 support missing in BISM Normalizer #30