Hello,
I'm receiving this error as below when I refresh power bi service dataflows:
Error: Encountered user gateway exception: '[DM_ErrorDetailNameCode_UnderlyingErrorCode]=-2147467259 [DM_ErrorDetailNameCode_UnderlyingHResult]=-2147467259 [Microsoft.Data.Mashup.ValueError.Detail]=_id [Microsoft.Data.Mashup.ValueError.Reason]=Expression.Error [InnerType]=MashupValueException The column '_id' of the table wasn't found. [GatewayPipelineErrorCode]=DM_GWPipeline_Gateway_MashupDataAccessError [ErrorShortName]=GatewayClientErrorResponseException[GatewayId=147809]/MashupDataAccessValueException[ErrorCode=-2147467259 HResult=-2147467259]/Wrapped(MashupValueException)[ErrorCode=-2147467259 HResult=-2147467259] [ExceptionErrorShortName]=GatewayClientErrorResponseException[GatewayId=147809]'. RootActivityId = e95476fc-d037-4a59-8af7-d24a01b1905a.Param1 = [DM_ErrorDetailNameCode_UnderlyingErrorCode]=-2147467259 [DM_ErrorDetailNameCode_UnderlyingHResult]=-2147467259 [Microsoft.Data.Mashup.ValueError.Detail]=_id [Microsoft.Data.Mashup.ValueError.Reason]=Expression.Error [InnerType]=MashupValueException The column '_id' of the table wasn't found. [GatewayPipelineErrorCode]=DM_GWPipeline_Gateway_MashupDataAccessError [ErrorShortName]=GatewayClientErrorResponseException[GatewayId=147809]/MashupDataAccessValueException[ErrorCode=-2147467259 HResult=-2147467259]/Wrapped(MashupValueException)[ErrorCode=-2147467259 HResult=-2147467259] [ExceptionErrorShortName]=GatewayClientErrorResponseException[GatewayId=147809] Request ID: 20ac22d7-9578-1117-9aca-c90e026de0c7.
I checked:
Gateway connection - ok
ODBC connection - ok
It was functioned but for some reason it didn't refresh anymore.
When entering in power query there is onther error for some of dataflows:
Error: PipelineException: ERROR [HY000] Elasticsearch Request Failed - 404 (search_context_missing_exception search_context_missing_exception search_context_missing_exception search_context_missing_exception search_context_missing_exception): No search context found for id [12669370] No search context found for id [36765292] No search context found for id [36765291] No search context found for id [12669369] No search context found for id [12669368] . RootActivityId = 59bb01a2-6de5-4f1f-a91e-b2e377b66bdc.Param1 = PipelineException: ERROR [HY000] Elasticsearch Request Failed - 404 (search_context_missing_exception search_context_missing_exception search_context_missing_exception search_context_missing_exception search_context_missing_exception): No search context found for id [12669370] No search context found for id [36765292] No search context found for id [36765291] No search context found for id [12669369] No search context found for id [12669368] Request ID: e4bde153-addc-1e58-c1f2-50ad3c058291.
Also this error it appears time after time and in the same way it disappear, no reason found from our side.
We are strunglying with those 2 errors so much and is very frustrating.
Please some body help and I can give and more specifications if needed.
thank you very much!
Mariola
