Could not load file or assembly 'Microsoft.Data.ConnectionUI.Dialog'

[MarekTTT]

I have problem connecting to the Microsoft SQL Server from SSAS Tabular project in Microsoft Visual Studio 2017 Community Edition. I created "Analysis service tabular project" in visual studio, then clicked on "Import from data source", choosed Microsoft SQL Server 2017, entered the server name but when I tried to verify the connection with "Test connection" option I got this exception:


============================
Error Message:
============================

Could not load file or assembly 'Microsoft.Data.ConnectionUI.Dialog, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. System cannot find given file.
----------------------------
Failed to connect to the server. Reason: Could not load file or assembly 'Microsoft.Data.ConnectionUI.Dialog, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. System cannot find given file.

============================
Call Stack:
============================

at Microsoft.AnalysisServices.BackEnd.RelationalDataSourceConnection.PrepareConnectionObject()
at Microsoft.AnalysisServices.BackEnd.RelationalDataSourceConnection.InitializeConnectionObject(String connectionIdentifier)
----------------------------
at Microsoft.AnalysisServices.BackEnd.RelationalDataSourceConnection.InitializeConnectionObject(String connectionIdentifier)
at Microsoft.AnalysisServices.BackEnd.RelationalDataSourceConnection.Open(String& connectionIdentifier)
at Microsoft.AnalysisServices.BackEnd.RelationalDataSourceConnection.Open()
at Microsoft.AnalysisServices.Common.DataSourceBasic.TestConnection()
at Microsoft.AnalysisServices.Common.DataSourceBasic.ClickTestConnection(Object progressControl)

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



I have no idea how to solve it since I have not found anything related to this about visual studio 2017. I will be thankful for every help.

Continue reading...