Error in refresh dataflow power bi service

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