Latest Enterprise DNA Initiatives


Dataflow Refresh Error in Power BI Service

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:

  1. Gateway - ok
  2. Odbc connector - successfully connected
  3. I can access the data and create the dataflow in power query pbi service. The SAVE step successfully
  4. Refresh failed :frowning:

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

Did you previously have a column named _id in the data?

In the error message you posted the below text stood out

The column ‘_id’ of the table wasn’t found.

Has this column been removed or renamed? This could be the cause.

Hi @mariola.dollani, did the response provided by @DavieJoe help in solving your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.

Hello @mariola.dollani, did the response above help solve your query? It’s been a while since we got a response from you. In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

Hi @mariola.dollani , due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.

Hello DavieJoe,
thank you for your comment.
There were some network problems at my company and the error it was solved by himself, suddenly it was refreshed.
br,
Mariola

1 Like