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
- leeedney9 years agoNew Member
Hi,
I'm a pro user and am definitely using the same user details!
The datasource I'm struggling with is the new one in beta, to connect PowerBI Desktop to the PowerBI Service. In our PowerBI Service we have a shared dataset in a group (that I have edit rights to) that I would like to connect to and make reports on, but when trying to connect to this I receive the errors I originally raised.
- wmorris209 years agoHelper II
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"}