search

BIDeveloperExtensions / bideveloperextensions

A Visual Studio extension that enhances development functionality in Business Intelligence Development Studio (BIDS) and SQL Server Data Tools (SSDT).
https://bideveloperextensions.github.io
Other
87 stars 24 forks source link

BIDS Helper encountered an error when Visual Studio started #119

Closed Laminaat closed 1 year ago

Laminaat commented 3 years ago

Describe the bug When working with a SSAS Tabular cube I noticed some functionality of BIDS Helper wasn't working anymore for me. I couldn't work with Tabular Display Folders. In the end I updated Visual Studio (Microsoft Visual Studio Community 2019 Version 16.8.3) and all underlying components of BIDS helper, as well as BIDS helper itself (which is the situation in the screenshots below). But the errors remained exactly the same.

I noticed that my SSDTBI Build version number was higher then what I saw in other issues posted here. But I'm not sure if this is related to my problem.

Version afbeelding

To Reproduce Steps to reproduce the behavior:

  1. Go to Model.bim (SSAS Tabular cube)
  2. Right Click on the Model.bim and click 'Tabular Display Folders'
  3. See error

Expected behavior Normally I could edit the Display Folders.

Screenshots afbeelding

Note I will gladly provide any extra information that might be necessary!

Laminaat commented 3 years ago

I found a simple workaround for this issue. The culprit seems to be the newest version of the Visual Studio extension: Microsoft Analysis Services Projects. Here you can find a download to revert back from 2.9.15 to 2.9.14.

The mantra of sticking with old software versions that you know that work instead of the latest and 'greatest' seems to hold true yet again when working with SQL and SSAS. 🤔 FYI, it is possible to disable auto update on Visual Studio extensions. Which I will do for now so that I can keep on working.

furmangg commented 1 year ago

We've published an updated release of BI Developer Extensions for Visual Studio 2019 that resolves this issue. Please note the compatible SSAS extension version.