3
Vote

VS 2015 - Add-in is not currently enabled

description

I installed BIDS helper using extensions and updates , and I can see it installed, and enabled in the window. However when I got to BIDS Helper in the Options menu it tells me the Add-in is not currently enabled. I'm not a full administrator of my machine, and I've seen issues similar to this on older versions, that are fixed with xCopy, but this doesn't seem to be an available solution for VS 2015.

When I Click on version it shows me the error that occurs (pasted below).
BIDS Helper encountered an error when Visual Studio started:
Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.
at System.Reflection.RuntimeModule.GetTypes(RuntimeModule module)
at System.Reflection.RuntimeModule.GetTypes()
at System.Reflection.Assembly.GetTypes()
at BIDSHelper.BIDSHelperPackage.Initialize() in C:\projects\BIDS Helper\dev\bidshelper-vsix\BidsHelperPackage.cs:line 108
Could not load file or assembly 'Microsoft.AnalysisServices.AppLocal, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].



Could not load file or assembly 'Microsoft.AnalysisServices.AppLocal, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].



Could not load file or assembly 'Microsoft.AnalysisServices.AppLocal, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].



Could not load file or assembly 'Microsoft.AnalysisServices.Common.FrontEnd, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].



Could not load file or assembly 'Microsoft.AnalysisServices.AppLocal.Core, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].



Could not load file or assembly 'Microsoft.AnalysisServices.AppLocal, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].



Could not load file or assembly 'Microsoft.AnalysisServices.Common.FrontEnd, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].



Could not load file or assembly 'Microsoft.DataTransformationServices.VsIntegration, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

Could not load file or assembly 'Microsoft.AnalysisServices.AppLocal.Core, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

Could not load file or assembly 'Microsoft.AnalysisServices.Common.FrontEnd, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]._

comments

furmangg wrote Apr 18 at 12:08 AM

Looks like you are not running the latest version of SSDT. Please upgrade and let us know if it solves the problem.

This issue will serve as a good work item for improving the error message here.

dgosbell wrote Apr 18 at 1:08 AM

Yes, it looks like either the version of SSDT is an old one or not all the SSDT-BI features are installed

ClayDoise wrote Apr 18 at 12:33 PM

I think I'm on the most current version already, see below info. Maybe there is a feature missing, but I can't tell which one.
Microsoft Visual Studio Professional 2015
Version 14.0.25431.01 Update 3
Microsoft .NET Framework
Version 4.6.01055

Installed Version: Professional

LightSwitch for Visual Studio 2015 00322-40000-00000-AA018
Microsoft LightSwitch for Visual Studio 2015

Microsoft Visual Studio Tools for Applications 2015 00322-40000-00000-AA018
Microsoft Visual Studio Tools for Applications 2015

Visual Basic 2015 00322-40000-00000-AA018
Microsoft Visual Basic 2015

Visual C# 2015 00322-40000-00000-AA018
Microsoft Visual C# 2015

Visual C++ 2015 00322-40000-00000-AA018
Microsoft Visual C++ 2015

Application Insights Tools for Visual Studio Package 7.18.00214.2
Application Insights Tools for Visual Studio

ASP.NET and Web Tools 2015.1 (Beta8) 14.1.11107.0
ASP.NET and Web Tools 2015.1 (Beta8)

ASP.NET Web Frameworks and Tools 2012.2 4.1.41102.0
For additional information, visit http://go.microsoft.com/fwlink/?LinkID=309563

ASP.NET Web Frameworks and Tools 2013 5.2.40314.0
For additional information, visit http://www.asp.net/

BIDSHelper Extension 2.0.1
BIDS Helper 2016 Visual Studio Extension v2.0.1 - An add-in to extend SQL Server Data Tools

Common Azure Tools 1.8
Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.

JavaScript Language Service 2.0
JavaScript Language Service

JavaScript Project System 2.0
JavaScript Project System

Microsoft Azure Mobile Services Tools 1.4
Microsoft Azure Mobile Services Tools

NuGet Package Manager 3.4.4
NuGet Package Manager in Visual Studio. For more information about NuGet, visit http://docs.nuget.org/.

Oracle Developer Tools for Visual Studio 12.1.0.2.4
Oracle Developer Tools for Visual Studio Copyright (c) 2005, 2015

PreEmptive Analytics Visualizer 1.2
Microsoft Visual Studio extension to visualize aggregated summaries from the PreEmptive Analytics product.

SQL Server Analysis Services 14.0.338.80
Microsoft SQL Server Analysis Services Designer
Version 14.0.338.80

SQL Server Data Tools 14.0.61703.020
Microsoft SQL Server Data Tools

SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 14.0.304.138

SQL Server Reporting Services 14.0.338.80
Microsoft SQL Server Reporting Services Designers
Version 14.0.338.80

TypeScript 1.8.36.0
TypeScript tools for Visual Studio

ClayDoise wrote Apr 20 at 2:23 PM

Uninstalling SSDT and re-installing the latest version at link below fixed my issue. https://msdn.microsoft.com/en-us/mt186501.aspx?f=255&MSPPError=-2147217396

wrote Apr 25 at 3:58 PM

bmwarren wrote Apr 28 at 3:33 PM

I've got this issue. I installed the latest version of SSDT (version 17.0) see version list below.

Microsoft Visual Studio Professional 2015
Version 14.0.25431.01 Update 3
Microsoft .NET Framework
Version 4.7.02046

Installed Version: Professional

Microsoft Visual Studio Tools for Applications 2015 00322-40000-00000-AA236
Microsoft Visual Studio Tools for Applications 2015

Visual Basic 2015 00322-40000-00000-AA236
Microsoft Visual Basic 2015

Visual C# 2015 00322-40000-00000-AA236
Microsoft Visual C# 2015

Visual C++ 2015 00322-40000-00000-AA236
Microsoft Visual C++ 2015

Application Insights Tools for Visual Studio Package 7.18.00214.2
Application Insights Tools for Visual Studio

ASP.NET and Web Tools 2015.1 14.1.21111.0
ASP.NET and Web Tools 2015.1

ASP.NET Web Frameworks and Tools 2012.2 4.1.41102.0
For additional information, visit http://go.microsoft.com/fwlink/?LinkID=309563

ASP.NET Web Frameworks and Tools 2013 5.2.40314.0
For additional information, visit http://www.asp.net/

Azure App Service Tools v2.9.6 14.0.21111.0
Azure App Service Tools v2.9.6

Azure Data Lake Node 1.0
This package contains the Data Lake integration nodes for Server Explorer.

Azure Data Lake Tools for Visual Studio 2.2.5000.0
Microsoft Azure Data Lake Tools for Visual Studio

BIDSHelper Extension 2.0.1
BIDS Helper 2016 Visual Studio Extension v2.0.1 - An add-in to extend SQL Server Data Tools

Common Azure Tools 1.8
Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.

JavaScript Language Service 2.0
JavaScript Language Service

JavaScript Project System 2.0
JavaScript Project System

Microsoft .NET Core Tools (Preview 2) 14.1.21111.0
Microsoft .NET Core Tools (Preview 2)

Microsoft Azure Hive Query Language Service 2.2.5000.0
Language service for Hive query

Microsoft Azure Mobile Services Tools 1.4
Microsoft Azure Mobile Services Tools

Microsoft Azure Tools 2.9
Microsoft Azure Tools for Microsoft Visual Studio 2015 - v2.9.41104.6

NuGet Package Manager 3.5.0
NuGet Package Manager in Visual Studio. For more information about NuGet, visit http://docs.nuget.org/.

PreEmptive Analytics Visualizer 1.2
Microsoft Visual Studio extension to visualize aggregated summaries from the PreEmptive Analytics product.

SQL Server Analysis Services 14.0.514.48
Microsoft SQL Server Analysis Services Designer
Version 14.0.514.48

SQL Server Data Tools 14.0.61704.140
Microsoft SQL Server Data Tools

SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 14.0.500.272

SQL Server Reporting Services 14.0.514.48
Microsoft SQL Server Reporting Services Designers
Version 14.0.514.48

ToolWindowHostedEditor 1.0
Hosting json editor into a tool window

TypeScript 1.8.36.0

TypeScript tools for Visual Studio

I get this when I look at the properties of BIDSHelper.

BIDS Helper encountered an error when Visual Studio started:
Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.
at System.Reflection.RuntimeModule.GetTypes(RuntimeModule module)
at System.Reflection.RuntimeModule.GetTypes()
at System.Reflection.Assembly.GetTypes()
at BIDSHelper.BIDSHelperPackage.Initialize() in C:\projects\BIDS Helper\dev\bidshelper-vsix\BidsHelperPackage.cs:line 108
Could not load file or assembly 'Microsoft.AnalysisServices.AppLocal, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].



Could not load file or assembly 'Microsoft.AnalysisServices.AppLocal, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].



Could not load file or assembly 'Microsoft.AnalysisServices.AppLocal, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].



Could not load file or assembly 'Microsoft.AnalysisServices.Common.FrontEnd, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].



Could not load file or assembly 'Microsoft.AnalysisServices.AppLocal.Core, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].



Could not load file or assembly 'Microsoft.AnalysisServices.AppLocal, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].



Could not load file or assembly 'Microsoft.AnalysisServices.Common.FrontEnd, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].



Could not load file or assembly 'Microsoft.DataTransformationServices.VsIntegration, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].



Could not load file or assembly 'Microsoft.AnalysisServices.AppLocal.Core, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].



Could not load file or assembly 'Microsoft.AnalysisServices.Common.FrontEnd, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

wrote Apr 28 at 3:33 PM

furmangg wrote Apr 28 at 10:14 PM

If your Help... About Microsoft Visual Studio says:
Microsoft SQL Server Analysis Services Designer
Version 14......

Then you are using the new SQL 2017 version of SSDT for VS2015. Currently that's not supported. If you must use that version then click furmangg and send me an email and you can help beta test as we get it ready.

For now, for BIDS Helper to be compatible in VS2015 you need to use the SSDT 16.5 for VS2015 found here:
https://docs.microsoft.com/en-us/sql/ssdt/previous-releases-of-sql-server-data-tools-ssdt-and-ssdt-bi

To know if you have that installed, your Help... About Microsoft Visual Studio will say:
Microsoft SQL Server Analysis Services Designer
Version 13.0.1701.8

Please give that an install and let me know if you have any issues.

xhead wrote May 1 at 4:01 PM

I added the following <bindingRedirect> entries to my C:\Users\mdiehl\AppData\Local\Microsoft\VisualStudio\14.0\devenv.exe.config file :

Under the <runtime><assemblyBinding>elements:
  <dependentAssembly>
    <assemblyIdentity name="Microsoft.AnalysisServices.AppLocal" publicKeyToken="89845dcd8080cc91" culture="neutral"/>
    <bindingRedirect oldVersion="13.0.0.0" newVersion="14.0.0.0"/>
  </dependentAssembly>

  <dependentAssembly>
    <assemblyIdentity name="Microsoft.AnalysisServices.Common.FrontEnd" publicKeyToken="89845dcd8080cc91" culture="neutral"/>
    <bindingRedirect oldVersion="13.0.0.0" newVersion="14.0.0.0"/>
  </dependentAssembly>

  <dependentAssembly>
    <assemblyIdentity name="Microsoft.AnalysisServices.AppLocal.Core" publicKeyToken="89845dcd8080cc91" culture="neutral"/>
    <bindingRedirect oldVersion="13.0.0.0" newVersion="14.0.0.0"/>
  </dependentAssembly>

  <dependentAssembly>
    <assemblyIdentity name="Microsoft.DataTransformationServices.VsIntegration" publicKeyToken="89845dcd8080cc91" culture="neutral"/>
    <bindingRedirect oldVersion="13.0.0.0" newVersion="14.0.0.0"/>
  </dependentAssembly>
In Tools/Options/BidsHelper I no longer get the binding errors. However, I still don't get any custom context menu items when I right click on a .BIM file in Solution explorer.

What I'm missing the most is the Display Folder editor for my tabular models. I can't checkin and deploy until I get this working. Am I heading in the right direction?

Greg, Darren, if there's anything I can do to get a workaround...

furmangg wrote May 1 at 11:18 PM

Xhead clever. We have emailed and this config file workaround shouldn't be needed as we are privately sharing an early beta build for VS2015 SSDT17.0. Others can contact me by clicking furmangg and shooting me an email.