Power BI Service data source - Couldn't retrieve the data for this visual. Please try again later

[mda]

Today in latest Desktop I tried to switch to a new data source from Power BI Service but it is failing.

I'm getting this message: Couldn't retrieve the data for this visual. Please try again later.

Timestamp: 2017-11-09T10:43:24.4946361Z

Session ID: 73e95735-b4dd-4093-89dd-abf0d2245c37

Release: November 2017

Product Version: 2.52.4921.461 (PBIDesktop) (x64)

Error Message: Couldn't retrieve the data for this visual. Please try again later.

OS Version: Microsoft Windows NT 10.0.15063.0 (x64 pl-PL)

CLR Version: 4.7 or later [Release Number = 460798]

IE Version: 11.483.15063.0

User ID: 53e1cf81-d99c-4f6d-91d6-ac4f68bfd61a

Activity ID: null

Stack Trace:
System.InvalidOperationException: No session exists for database with ID:18975152-20a4-4cea-8098-5e56ce31abd2
at Microsoft.PowerBI.ReportingServicesHost.PowerViewHandler.GetActiveSession(String databaseID)
at Microsoft.PowerBI.ReportingServicesHost.ActiveReportingSessionConnectionPool.Get(IDataSourceInfo dataSourceInfo)
at Microsoft.DataShaping.Processing.QueryExecutionCommon.ConnectionWrapper.<>c__DisplayClass10_0.<<OpenConnection>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.ReportingServicesHost.DataShapingTelemetryService.<RunInAsyncActivity>d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DataShaping.Processing.QueryExecutionCommon.ConnectionWrapper.<OpenConnection>d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DataShaping.Processing.QueryExecutionCommon.QueryExecutor`1.<RunQueryAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DataShaping.Processing.QueryExecution.QueryExecutionParallelStrategy.<RunQueriesAsync>d__1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DataShaping.Processing.QueryExecution.QueryExecutionManager.<>c__DisplayClass16_0.<<RunQueriesAsync>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.ReportingServicesHost.DataShapingTelemetryService.<RunInAsyncActivity>d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DataShaping.Processing.QueryExecution.QueryExecutionManager.<RunQueriesAsync>d__16.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DataShaping.Processing.DataShapeProcessor.<ExecuteQueryAndWriteResult>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.DataShaping.Processing.DataShapeProcessor.<ExecuteQueryAndWriteResult>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.DataShaping.Processing.DataShapeProcessor.<ExecuteQueryAndWriteResult>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DataShaping.Processing.DataShapeProcessor.<ProcessImpl>d__1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.ReportingServicesHost.DataShapingTelemetryService.<RunInAsyncActivity>d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DataShaping.Engine.DataShapeProcessingHost.<InvokeProcessingAsync>d__4.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DataShaping.Engine.DataShapeEngine.<ExecuteSemanticQueryAsyncImpl>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.ReportingServicesHost.DataShapingTelemetryService.<RunInAsyncActivity>d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.DataShaping.Common.TaskUtils.WaitAndUnwrap(Task task)
at Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.ExecuteDataQueryWithDataShapeEngine(IQueryResultDataWriter queryResultDataWriter, EntityDataModel model, IConceptualSchema schema, DataQuery query, Int32 queryId, ServiceErrorStatusCode& serviceErrorStatusCode)
at Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.ProcessAndWriteSemanticQueryCommands(IQueryResultsWriter queryResultsWriter, ExecuteSemanticQueryRequest request, IConceptualSchema conceptualSchema, EntityDataModel model)

[v-jiascu-msft]

Thank you, @mda

Best Regards,

Dale

[davisbizhq]

However, unfortunately, it is again surfacing in Version: 2.53.4954.82 64-bit.  For a more thorough explanation of the problem and workaround, please see http://community.powerbi.com/t5/Desktop/Change-dataset-for-quot-Power-BI-service-quot-live-connectio....  

The other unfortunate thing is that the catalyst isn't clear -- is just starts happening for no apparent reason.