Due to big data (millions of row) we work with dataflow created in power bi service and we have license PPU.
Until before 2 days the dataflows were refreshed ok. Suddenly yesterday we faced the error as below.
In one mement the refresh it was successful but didn’t retrieve the full data (rows were missing) and again failed.
We tried to create new dataflows, with 10 rows or less from the same source and the refresh failed again.
I checked:
- Gateway - ok
- Odbc connector - successfully connected
- I can access the data and create the dataflow in power query pbi service. The SAVE step successfully
- Refresh failed
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 = c2cd792e-225e-4c12-81e6-ec0c6cf1d2c1.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: 6aaabde6-e272-f47e-242e-894955bbfa35.
Please your support and help!
Thank you in advance!
Mariola