Forum Discussion
Problems getting data from the Power BI Service connection
I have tested it on my local environment, we cannot reproduce this issue. Are you a pro user or free user? Please ensure that you used the same user on Power BI services and Power BI desktop. Then which type of datasource did you connected? Please provide us more detail information so that we can try to reproduce this issue and make further analysis.
Regards,
Charlie Liao
For me, I am a Pro User and connecting via web data source (wiki). I have also tried SharePoint Online data source with the same error. Here is the trace I ran with the error that was thrown:
DataMashup.Trace Critical: 24579 : {"Start":"2017-04-12T13:44:19.2937498Z","Action":"PBI.Win.ProcessingError","Message":"{\"ExceptionType\":\"Microsoft.DataShaping.InternalContracts.DataExtensionException\",\"stackTrace\":\" at Microsoft.DataShaping.DataExtension.Connection.OpenImpl()\\r\\n at Microsoft.DataShaping.Common.TaskUtils.RunSynchronously(Action action)\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\\r\\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n at Microsoft.PowerBI.ReportingServicesHost.PoolableConnectionWrapper.\\u003cOpenAsync\\u003ed__3.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\\r\\n at Microsoft.PowerBI.ReportingServicesHost.Utils.TaskExtensions.WaitAndUnwrapException[T](Task`1 task)\\r\\n at Microsoft.PowerBI.ReportingServicesHost.LocalReportProcessingHost.GetModelMetadata(IASConnectionInfo connectionInfo, DataSourceInfo dataSourceInfo, IDbConnectionPool connectionPool, ITracer tracer, String modelMetadataVersion, IConnectionUserImpersonator connectionUserImpersonator)\\r\\n at Microsoft.PowerBI.ReportingServicesHost.DataShapingHelper.GetModelMetadata(IPowerViewEngine powerViewEngine, IDbConnectionPool connectionPool, DataSourceInfo dataSourceInfo, IASConnectionInfo asConnectionInfo, Boolean useMsolapForCsdl, IConnectionUserImpersonator connectionUserImpersonator)\",\"message\":\"GetModelAsStream\",\"sessionId\":\"7f3fd214-ef3a-48ec-a906-0b3ff32d7115\",\"deviceId\":\"c27db501\",\"userId\":\"abaeb732-8dc5-479b-9795-dcf0ef8d8cbe\",\"isInternal\":\"False\",\"authenticatedUserId\":\"acca61a5-cdc6-4848-aeca-9d61622d66f7\"}","ProductVersion":"2.45.4704.442 (PBIDesktop)","ActivityId":"cd0332b1-a6f2-4989-bcac-1f85c848bc2f","Process":"PBIDesktop","Pid":9604,"Tid":13,"Duration":"-00:00:00.0535798"}
DataMashup.Trace Critical: 24579 : {"Start":"2017-04-12T13:44:19.2957508Z","Action":"PBI.Win.GetConceptualSchemaError","Message":"{\"stackTrace\":\"Microsoft.DataShaping.InternalContracts.DataExtensionException: 61E010F32D4297B0AD0FBF721D61C803B7939FA498F006C82BF9639AA078A893 ---\\u003e MsolapWrapper.MsolapWrapperException: DF2353BD608A966AE68495908F9AD2D3B9942291BF8DDC7FE19E65BC36C5679D\\r\\n at MsolapWrapper.Utils.ThrowErrorIfHrFailed(Int32 hr, String message)\\r\\n at MsolapWrapper.Connection.Open()\\r\\n at Microsoft.DataShaping.DataExtension.Connection.OpenImpl()\\r\\n --- End of inner exception stack trace ---\\r\\n at Microsoft.DataShaping.DataExtension.Connection.OpenImpl()\\r\\n at Microsoft.DataShaping.Common.TaskUtils.RunSynchronously(Action action)\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\\r\\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n at Microsoft.PowerBI.ReportingServicesHost.PoolableConnectionWrapper.\\u003cOpenAsync\\u003ed__3.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\\r\\n at Microsoft.PowerBI.ReportingServicesHost.Utils.TaskExtensions.WaitAndUnwrapException[T](Task`1 task)\\r\\n at Microsoft.PowerBI.ReportingServicesHost.LocalReportProcessingHost.GetModelMetadata(IASConnectionInfo connectionInfo, DataSourceInfo dataSourceInfo, IDbConnectionPool connectionPool, ITracer tracer, String modelMetadataVersion, IConnectionUserImpersonator connectionUserImpersonator)\\r\\n at Microsoft.PowerBI.ReportingServicesHost.DataShapingHelper.GetModelMetadata(IPowerViewEngine powerViewEngine, IDbConnectionPool connectionPool, DataSourceInfo dataSourceInfo, IASConnectionInfo asConnectionInfo, Boolean useMsolapForCsdl, IConnectionUserImpersonator connectionUserImpersonator)\\r\\n at Microsoft.PowerBI.ReportingServicesHost.ReportingSession.GetModel(String dataSourceName)\\r\\n at Microsoft.PowerBI.ReportingServicesHost.ReportingSession.GetModelAsStream(String dataSourceName)\\r\\n at Microsoft.PowerBI.ReportingServicesHost.ReportingSession.GetModelContext()\\r\\n at Microsoft.PowerBI.ReportingServicesHost.PowerViewHandler.GetModel(String databaseID)\\r\\n at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.GetModelStream(ExploreClientHandlerContext context, String databaseID)\",\"message\":\"Cannot retrieve the data model due to: Failed to open the MSOLAP connection.\",\"sessionId\":\"7f3fd214-ef3a-48ec-a906-0b3ff32d7115\",\"deviceId\":\"c27db501\",\"userId\":\"abaeb732-8dc5-479b-9795-dcf0ef8d8cbe\",\"isInternal\":\"False\",\"authenticatedUserId\":\"acca61a5-cdc6-4848-aeca-9d61622d66f7\"}","ProductVersion":"2.45.4704.442 (PBIDesktop)","ActivityId":"06cee90b-f1b6-446c-84d1-5892eb37c7e1","Process":"PBIDesktop","Pid":9604,"Tid":13,"Duration":"-00:00:00.0543133"}
DataMashup.Trace Information: 24579 : {"Start":"2017-04-12T13:44:19.2478606Z","Action":"SharedLocalStorageAccessor/AcquireMutex","ProductVersion":"2.45.4704.442 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":9604,"Tid":31,"Duration":"00:00:00.0000221"}
DataMashup.Trace Information: 24579 : {"Start":"2017-04-12T13:44:19.2478239Z","Action":"UISettingsStorage/GetSettings","MetadataSet":[["FileHistory",6478],["PowerBIServiceFileHistory",2],["SSRSFileHistory",2],["AutoRecoveryFileLocation",73],["DisplayCommandBar","0"],["EditorTaskPaneWidth","266"],["QueriesEditorWindowScale_Left","184"],["QueriesEditorWindowScale_Top","0"],["QueriesEditorWindowScale_Width","1182"],["QueriesEditorWindowScale_Height","544"],["QueriesEditorWindowScale_Maximized","1"],["multiArtifactQueriesEditorRibbonQat",326],["MultiArtifactEditorWindowScale_Left","99"],["MultiArtifactEditorWindowScale_Top","0"],["MultiArtifactEditorWindowScale_Width","1166"],["MultiArtifactEditorWindowScale_Height","528"],["MultiArtifactEditorWindowScale_Maximized","1"],["multiArtifactEditorRibbonQat",442],["FormulaBuilderHistory",18706],["ShowStartPageForDataInsightsSummit2016","0"],["showStartPage","0"],["LastKnownPBICloudConfig",2244],["DisplayFormulaBar","1"],["ViewFormulaWindowScale_Left","448"],["ViewFormulaWindowScale_Top","136"],["ViewFormulaWindowScale_Width","1024"],["ViewFormulaWindowScale_Height","768"],["ViewFormulaWindowScale_Maximized","0"],["NavigatorDialogMasterPaneWidth","569"],["ShowImportCustomVisualSecurityWarningDialog","0"],["EditorNavigatorWidth","217"],["MaxCacheSize","4294967296"],["UseFixedWidthFont","0"],["AlwaysAllowParameterization","0"],["DisableNativeDbQueries","0"],["WebPreviewWarningLevel","1"],["DisableUpdateNotification","0"]],"ProductVersion":"2.45.4704.442 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":9604,"Tid":31,"Duration":"00:00:00.0003450"}
DataMashup.Trace Information: 24579 : {"Start":"2017-04-12T13:44:19.2498016Z","Action":"SharedLocalStorageAccessor/AcquireMutex","ProductVersion":"2.45.4704.442 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":9604,"Tid":31,"Duration":"00:00:00.0000169"}
DataMashup.Trace Information: 24579 : {"Start":"2017-04-12T13:44:19.2497771Z","Action":"UISettingsStorage/GetSettings","MetadataSet":[["FileHistory",6478],["PowerBIServiceFileHistory",2],["SSRSFileHistory",2],["AutoRecoveryFileLocation",73],["DisplayCommandBar","0"],["EditorTaskPaneWidth","266"],["QueriesEditorWindowScale_Left","184"],["QueriesEditorWindowScale_Top","0"],["QueriesEditorWindowScale_Width","1182"],["QueriesEditorWindowScale_Height","544"],["QueriesEditorWindowScale_Maximized","1"],["multiArtifactQueriesEditorRibbonQat",326],["MultiArtifactEditorWindowScale_Left","99"],["MultiArtifactEditorWindowScale_Top","0"],["MultiArtifactEditorWindowScale_Width","1166"],["MultiArtifactEditorWindowScale_Height","528"],["MultiArtifactEditorWindowScale_Maximized","1"],["multiArtifactEditorRibbonQat",442],["FormulaBuilderHistory",18706],["ShowStartPageForDataInsightsSummit2016","0"],["showStartPage","0"],["LastKnownPBICloudConfig",2244],["DisplayFormulaBar","1"],["ViewFormulaWindowScale_Left","448"],["ViewFormulaWindowScale_Top","136"],["ViewFormulaWindowScale_Width","1024"],["ViewFormulaWindowScale_Height","768"],["ViewFormulaWindowScale_Maximized","0"],["NavigatorDialogMasterPaneWidth","569"],["ShowImportCustomVisualSecurityWarningDialog","0"],["EditorNavigatorWidth","217"],["MaxCacheSize","4294967296"],["UseFixedWidthFont","0"],["AlwaysAllowParameterization","0"],["DisableNativeDbQueries","0"],["WebPreviewWarningLevel","1"],["DisableUpdateNotification","0"]],"ProductVersion":"2.45.4704.442 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":9604,"Tid":31,"Duration":"00:00:00.0004686"}
DataMashup.Trace Information: 24579 : {"Start":"2017-04-12T13:44:19.6840077Z","Action":"Ajax/Call","AjaxUrl":"/My%20Workspace/SimpleDialog/ErrorDialog","AjaxRequest":11,"AjaxRequestType":"application/x-www-form-urlencoded","AjaxResponse":820,"AjaxResponseType":null,"AjaxResponseStatusCode":200,"ProductVersion":"2.45.4704.442 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":9604,"Tid":1,"Duration":"00:00:00.0004611"}