Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Error "Report couldn`t access the data source , contact author" for few users who are part of RLS group
On premises Gateway logs:
DM.EnterpriseGateway Error: 0 : 2021-01-27T22:29:24.5418476Z DM.EnterpriseGateway fe158154-0f6f-430c-947e-e2b189ab4248 f29a2ad6-d6a2-5d24-04ef-166e14368f4f MGEO 4a3fcba8-1025-4ea2-a190-88012a911fce 3d942105-06c5-44d4-81c5-d45ca35de7c1 3d942105-06c5-44d4-81c5-d45ca35de7c1 AA1668A5 [DM.GatewayCore] Oledb Command Text Exception :
DM.EnterpriseGateway Error: 0 : 2021-01-27T22:29:24.5418476Z DM.EnterpriseGateway fe158154-0f6f-430c-947e-e2b189ab4248 f29a2ad6-d6a2-5d24-04ef-166e14368f4f MGEO 4a3fcba8-1025-4ea2-a190-88012a911fce 3d942105-06c5-44d4-81c5-d45ca35de7c1 3d942105-06c5-44d4-81c5-d45ca35de7c1 8083E0C6 [DM.GatewayCore] OleDbConnectionInfo Dispose threw exception: System.Runtime.InteropServices.COMException (0x80040E05): Exception from HRESULT: 0x80040E05
at Microsoft.PowerBI.DataMovement.Pipeline.OleDbBase.IDBInitialize.Uninitialize()
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.OleDbConnectionInfo.Dispose()
DM.EnterpriseGateway Error: 0 : 2021-01-27T22:29:24.8074695Z DM.EnterpriseGateway 02d4f152-3f49-4dc8-ad47-42e2b733a1b5 f29a2ad6-d6a2-5d24-04ef-166e14368f4f MGEF 4a3fcba8-1025-4ea2-a190-88012a911fce 3d942105-06c5-44d4-81c5-d45ca35de7c1 3d942105-06c5-44d4-81c5-d45ca35de7c1 9F2D060E [DM.Pipeline.Common] Non-gateway exception encountered in activity scope: System.Runtime.InteropServices.COMException (0x80004005): An unexpected exception occurred.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at Microsoft.PowerBI.DataMovement.Pipeline.OleDbBase.ICommandTextExtensions.ExecuteMultipleResults(ICommandText commandText, DBPARAMS* parameters)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayPipelineTelemetry.PipelineTelemetryService.ExecuteInActivity[T](PipelineActivityType pipelineActivityType, Func`1 action)
DM.EnterpriseGateway Error: 0 : 2021-01-27T22:29:24.8074695Z DM.EnterpriseGateway 02d4f152-3f49-4dc8-ad47-42e2b733a1b5 f29a2ad6-d6a2-5d24-04ef-166e14368f4f MGEF 4a3fcba8-1025-4ea2-a190-88012a911fce 3d942105-06c5-44d4-81c5-d45ca35de7c1 3d942105-06c5-44d4-81c5-d45ca35de7c1 365E69D1 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=75, err=COMException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2021-01-27T22:29:24.8074695Z DM.EnterpriseGateway fe158154-0f6f-430c-947e-e2b189ab4248 f29a2ad6-d6a2-5d24-04ef-166e14368f4f MGEO 4a3fcba8-1025-4ea2-a190-88012a911fce 3d942105-06c5-44d4-81c5-d45ca35de7c1 3d942105-06c5-44d4-81c5-d45ca35de7c1
Was it connected to SSAS? If you have "Live connection" set up people viewing the dashboard must have access to the data source, please refer to Manage your data source - Analysis Services - Power BI | Microsoft Docs
You can use "import" instead and scheduled refresh to avoid this.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
"An unexpected exception occurred." That's rather not helpful.
Anyway, please provide more context.
Assuming you have a PRO license - you can submit tickets to Microsoft from the support page.