cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bkokster
New Member

DM.EnterpriseGateway Error when applying filter on Slicer

Hi,

 

I've successfully connected to an on prem SSAS cube through the gateway.

I can create a simple visual with a measure and dimension on the axis.

However, when I add a slicer with this same dimension, and click on one of the values in the slicer, I get a "Can't display the visual" error message on the graph. I also get a "There was a data source access error. Please contact the Gateway Administrator" error on the ribbon on the top of the report.

When I create the same report on my Powerbi desktop using the same datasource, everything works fine so I assumed it's a gateway error.

I show the logs from the gateway below, thanks in advance for any advice/help:

 

DM.EnterpriseGateway Error: 0 : 2017-11-20T09:05:55.0220617Z DM.EnterpriseGateway ef503f9d-91d9-4a86-8ddd-cbdc854ce9ba 802cf05a-47f3-2cbd-abdd-9d95ccc8d7df MGEF b99ffa21-31f9-4bac-acd9-00ac9ab63b42 A22C0E71 [DM.Pipeline.Common] Non-gateway exception encountered in activity scope: System.Runtime.InteropServices.COMException (0x80004005): Internal error: 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.Common.Diagnostics.PipelineTelemetryService.ExecuteInActivity[T](PipelineActivityType pipelineActivityType, Func`1 action)
DM.EnterpriseGateway Error: 0 : 2017-11-20T09:05:55.0220617Z DM.EnterpriseGateway ef503f9d-91d9-4a86-8ddd-cbdc854ce9ba 802cf05a-47f3-2cbd-abdd-9d95ccc8d7df MGEF b99ffa21-31f9-4bac-acd9-00ac9ab63b42 07B910BA [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=41, err=COMException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2017-11-20T09:05:55.0220617Z DM.EnterpriseGateway bf1ef80d-1eb3-4973-9bb1-1981fc028c94 802cf05a-47f3-2cbd-abdd-9d95ccc8d7df MGEO b99ffa21-31f9-4bac-acd9-00ac9ab63b42 ADC5B8F4 [DM.GatewayCore] Oledb Command Text Causing Error : <pi>EVALUATE
CALCULATETABLE(
ROW(

 

....[removed by me]


),
KEEPFILTERS(
TREATAS(


....[removed by me]

 

)
)
)</pi>
DM.EnterpriseGateway Warning: 0 : 2017-11-20T09:05:55.0230609Z DM.EnterpriseGateway bf1ef80d-1eb3-4973-9bb1-1981fc028c94 802cf05a-47f3-2cbd-abdd-9d95ccc8d7df MGEO b99ffa21-31f9-4bac-acd9-00ac9ab63b42 0F193915 [DM.GatewayCore] Error while destroying OLE DB connection after failed query execution: 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()
at Microsoft.PowerBI.DataMovement.Pipeline.Common.PoolObject`2.Dispose()
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.OleDbRequestSessionBase`2.SafeDestroy()
DM.EnterpriseGateway Warning: 0 : 2017-11-20T09:05:55.0230609Z DM.EnterpriseGateway bf1ef80d-1eb3-4973-9bb1-1981fc028c94 802cf05a-47f3-2cbd-abdd-9d95ccc8d7df MGEO b99ffa21-31f9-4bac-acd9-00ac9ab63b42 12DB96CB [DM.GatewayCore] Swallowing exception during processing of OleDbCreateRowsetRequest attempt #1 and triggering a retry: System.Runtime.InteropServices.COMException (0x80004005): Internal error: 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.Common.Diagnostics.PipelineTelemetryService.ExecuteInActivity[T](PipelineActivityType pipelineActivityType, Func`1 action)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.OleDbProcessor.<>c__DisplayClass4_0.<ExecuteOleDbQuery>b__1(IOleDbRequestSession requestSession)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.OleDbProcessor.ProcessRequest[TRequest](GatewaySerializationContext serverContext, TRequest request, OleDbInternalErrorKind errorKind, Func`2 operation, Action onOperationFailure, Guid requestId)
DM.EnterpriseGateway Information: 0 : 2017-11-20T09:05:55.0750640Z DM.EnterpriseGateway b0a078b6-984a-4ae5-b9de-b14e8c4e8855 802cf05a-47f3-2cbd-abdd-9d95ccc8d7df MGON b99ffa21-31f9-4bac-acd9-00ac9ab63b42 F057BA5F [DM.GatewayCore] Gateway: EffectiveUserName: <pi>benji@datadiscovery.local</pi>, Datasource: DATADISC-02\DDSQL1, Catalog: DA Full Insurance Cube 201708
DM.EnterpriseGateway Information: 0 : 2017-11-20T09:05:55.1300609Z DM.EnterpriseGateway c8ada7e4-f437-4520-bede-b288d83e2ad3 802cf05a-47f3-2cbd-abdd-9d95ccc8d7df MGOM b99ffa21-31f9-4bac-acd9-00ac9ab63b42 669527D0 [DM.GatewayCore] Optional command property c8b522be-5cf3-11ce-ade5-00aa0044773d:BOOKMARKS is not supported by MSOLAP.5
DM.EnterpriseGateway Error: 0 : 2017-11-20T09:05:55.1390584Z DM.EnterpriseGateway da9bd418-dbca-4512-adec-1bf6753e96e4 802cf05a-47f3-2cbd-abdd-9d95ccc8d7df MGEF b99ffa21-31f9-4bac-acd9-00ac9ab63b42 A22C0E71 [DM.Pipeline.Common] Non-gateway exception encountered in activity scope: System.Runtime.InteropServices.COMException (0x80004005): Internal error: 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.Common.Diagnostics.PipelineTelemetryService.ExecuteInActivity[T](PipelineActivityType pipelineActivityType, Func`1 action)
DM.EnterpriseGateway Error: 0 : 2017-11-20T09:05:55.1390584Z DM.EnterpriseGateway da9bd418-dbca-4512-adec-1bf6753e96e4 802cf05a-47f3-2cbd-abdd-9d95ccc8d7df MGEF b99ffa21-31f9-4bac-acd9-00ac9ab63b42 D17DC4FC [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=9, err=COMException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2017-11-20T09:05:55.1390584Z DM.EnterpriseGateway bf1ef80d-1eb3-4973-9bb1-1981fc028c94 802cf05a-47f3-2cbd-abdd-9d95ccc8d7df MGEO b99ffa21-31f9-4bac-acd9-00ac9ab63b42 ADC5B8F4 [DM.GatewayCore] Oledb Command Text Causing Error : <pi>EVALUATE
CALCULATETABLE(
ROW(

 


....[removed by me]


),
KEEPFILTERS(
TREATAS(
{

 

....[removed by me]

 


)
)
)</pi>
DM.EnterpriseGateway Warning: 0 : 2017-11-20T09:05:55.1400612Z DM.EnterpriseGateway bf1ef80d-1eb3-4973-9bb1-1981fc028c94 802cf05a-47f3-2cbd-abdd-9d95ccc8d7df MGEO b99ffa21-31f9-4bac-acd9-00ac9ab63b42 0F193915 [DM.GatewayCore] Error while destroying OLE DB connection after failed query execution: 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()
at Microsoft.PowerBI.DataMovement.Pipeline.Common.PoolObject`2.Dispose()
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.OleDbRequestSessionBase`2.SafeDestroy()
DM.EnterpriseGateway Error: 0 : 2017-11-20T09:05:55.1400612Z DM.EnterpriseGateway bf1ef80d-1eb3-4973-9bb1-1981fc028c94 802cf05a-47f3-2cbd-abdd-9d95ccc8d7df MGEO b99ffa21-31f9-4bac-acd9-00ac9ab63b42 8A86571C [DM.Pipeline.Diagnostics] Exception object created [IsBenign=True]: Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.OleDbCreateRowsetFailedException: Error creating OLE DB row set.; ErrorShortName: OleDbCreateRowsetFailedException[ErrorCode=-2147467259,HResult=-2147467259]/Wrapped(COMException)[ErrorCode=-2147467259,HResult=-2147467259]
DM.EnterpriseGateway Error: 0 : 2017-11-20T09:05:55.1400612Z DM.EnterpriseGateway bf1ef80d-1eb3-4973-9bb1-1981fc028c94 802cf05a-47f3-2cbd-abdd-9d95ccc8d7df MGEO b99ffa21-31f9-4bac-acd9-00ac9ab63b42 E189E2FE [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=160, err=OleDbCreateRowsetFailedException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2017-11-20T09:05:55.1410607Z DM.EnterpriseGateway 788747c6-4fa2-4c7f-9b06-e4099dea1684 802cf05a-47f3-2cbd-abdd-9d95ccc8d7df MGPP b99ffa21-31f9-4bac-acd9-00ac9ab63b42 7CFD80FC [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=162, err=OleDbCreateRowsetFailedException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2017-11-20T09:05:55.1420631Z DM.EnterpriseGateway 400bd3ee-b72d-4fc7-85df-a747a7a4084e 802cf05a-47f3-2cbd-abdd-9d95ccc8d7df MDSR b99ffa21-31f9-4bac-acd9-00ac9ab63b42 FABD301D [DM.GatewayCore] Error processing request: [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.OleDbCreateRowsetFailedException: Error creating OLE DB row set.

2 REPLIES 2
Moderator v-yuezhe-msft
Moderator

Re: DM.EnterpriseGateway Error when applying filter on Slicer

@bkokster,

I am not able to reproduce your issue in Power BI Service. Do you get same error when you connect to other cubes?

Also please share us the complete gateway log which is located at C:\Users\PBIEgwService\AppData\Local\Microsoft\on-premises data gateway\Gateway*.log . You can upload the gateway log to OneDrive and post shared link of the file here.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
stevexnitro
New Member

Re: DM.EnterpriseGateway Error when applying filter on Slicer

Hi bkokster,

 

I'm experiencing the same behavior in my environment. I assume this error has something to do with gateway and .NET libraries installed. I'm getting this issue only for certain visuals or reports, others work fine. I tried reinstalling enterprise gateway but I can't do that as I receive various errors during the re-installation. Seems like my Enterprise gateway installation is corrupt in a way resulting in this intermittent itching errors.

 

Did you, by any chance, come to a resolution of your problem?

 

Thanks,

Stepan

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors