Power BI Desktop - Get Data error

[samr]

Hi. I am unable to get data from a SQL Server source in Power BI Desktop. Note, I am able to connect to the same data source using the same user account via SSMS. Do you have any ideas as to what is going on? The steps leading to the error and the error message are below.

1. Get Data
2. Sql Server
3. Select views and load --> Error

Feedback Type:
Frown (Error)

Error Message:
A connection cannot be made. Ensure that the server is running.

Stack Trace:

Server stack trace:
   at Microsoft.AnalysisServices.XmlaClient.OpenConnection(ConnectionInfo connectionInfo, Boolean& isSessionTokenNeeded)
   at Microsoft.AnalysisServices.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
   at Microsoft.AnalysisServices.XmlaClient.Reconnect()
   at Microsoft.AnalysisServices.Core.Server.Reconnect()
   at Microsoft.PowerBI.Modeler.ServerUtilities.EnsureConnectionAndExecuteAction(Server server, Action action)
   at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.ExtendedModelChangeScope.<Finish>b__21()
   at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass3.<SendAndMarshalExceptions>b__0(Object null)

Exception rethrown at [0]:
   at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.SendAndMarshalExceptions(SynchronizationContext context, Action callback)
   at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.ExtendedModelChangeScope.Finish()
   at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.<>c__DisplayClassf.<RunExtendedModelChangeAsync>b__e()
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.Tasks.Task.Execute()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Microsoft.PowerBI.Client.Windows.Utilities.TaskExtensions.WaitAndUnpackException(Task task)
   at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelLoader.PerformLoadInternal(Action relationshipAutodetectStartCallback, ModelChange modelChangeToExecuteBeforeSchemaSync, Boolean skipImpactAnalysisWarning)
   at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelLoader.<>c__DisplayClass2.<PerformLoadAsync>b__0()
   at Sys

[v-qiuyu-msft]

Hi @samr,

1. Please open Query Editor, click on New Source -> SQL database to connect to the same instance, select the view. If the data displays in Query Editor, then click on Apply to load data to data model to see if the same issue occurs. 

2. Please use SQL profiler then repeat steps to load data to see if any error captured. 

3. Please run the latest Power BI desktop version if possible. 

Best Regards,
Qiuyun Yu