Forum Discussion

brianarwiley's avatar
brianarwiley
Frequent Visitor
1 year ago
Solved

Dataflow Gen 2 Mashup Error

I have a gen 2 dataflow that was running fine until Tuesday morning (yesterday) when it first started giving me this error: 

There was a problem refreshing the dataflow: 'Something went wrong, please try again later. If the error persists, please contact support.'. Error code: ActionUserFailure. (Request ID: 44e5a7d5-0c25-4f09-af74-e9aa4bdb536e).
SalesOutlook_WriteToDataDestination: There was a problem refreshing the dataflow: 'Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: Expression.Error: Error in replacing table's content with new data in a version: #{0}., InnerException: We cannot convert the value #{0} to type #{1}., Underlying error: We cannot convert the value null to type Number. Details: Reason = Expression.Error;ErrorCode = Lakehouse036;Message = We cannot convert the value null to type Number.;Message.Format = We cannot convert the value #{0} to type #{1}.;Message.Parameters = {"null", "Number"};ErrorCode = 10277;Microsoft.Data.Mashup.Error.Context = User'. Error code: Mashup Exception Expression Error. (Request ID: 44e5a7d5-0c25-4f09-af74-e9aa4bdb536e).
 
I went back through all the tables I am connected to in my dataflow, made sure all the connections are correct, made sure any column that is any sort of number has the nulls replaced with 0, and even dropped and resaved my views that I am using to make custom tables for this dataflow. I dropped the table my dataflow has saved to, and readded that as well. 

The error message then got smaller to this:

There was a problem refreshing the dataflow: 'Something went wrong, please try again later. If the error persists, please contact support.'. Error code: ActionUserFailure. (Request ID: 6d32f965-0d21-408a-81dc-11425b382127).
SalesOutlook_WriteToDataDestination: There was a problem refreshing the dataflow: 'Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: Expression.Error: We cannot convert the value null to type Number. Details: Reason = Expression.Error;ErrorCode = 10277;Microsoft.Data.Mashup.Error.Context = User'. Error code: Mashup Exception Expression Error. (Request ID: 6d32f965-0d21-408a-81dc-11425b382127).
 
It's a similar if not the same error, but I am lost at what to try next. 
workspaces
  • v-csrikanth's avatar
    v-csrikanth
    1 year ago

    Hi brianarwiley 
    Sorry for the inconvenience occurred and for the late reply.
    There was a bug that was identified and resolved the issue last week. If your issue still persists, please attach an error screenshot.

    If the above information helps you, please give us a Kudos and marked the reply as a solution.

    Thanks,
    Cheri Srikanth

     

10 Replies

  • v-csrikanth's avatar
    v-csrikanth
    Community Support
    1 year ago

    Hi brianarwiley 
    Sorry for the inconvenience occurred and for the late reply.
    There was a bug that was identified and resolved the issue last week. If your issue still persists, please attach an error screenshot.

    If the above information helps you, please give us a Kudos and marked the reply as a solution.

    Thanks,
    Cheri Srikanth

     

  • v-csrikanth's avatar
    v-csrikanth
    Community Support
    1 year ago

    Hi brianarwiley 

    Please let us know if you need any further assistance.

    Looking forward to your update!

    If the above information helps you, please give us a Kudos and marked the reply as a solution.

    Thanks,
    Cheri Srikanth

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi v-csrikanth, I have a similar issue:

    DS_DIGITAL_TRX_WriteToDataDestination: There was a problem refreshing the dataflow: 'Something went wrong, please try again later. If the error persists, please contact support.'. Error code: 999999. (Request ID: 2f8eabf0-8178-4144-96da-b6b63c5a9a2d).

    I don't know about this, can you help me? thank you

     

     

  • harshaduggi's avatar
    harshaduggi
    Frequent Visitor
    1 year ago

    I am facing the same issue. when i edit the flow every table loads and shows the data. but when i save and run the dataflow gen 2 it runs for 3 mins and fails 

    show the below error:
    There was a problem refreshing the dataflow: 'Something went wrong, please try again later. If the error persists, please contact support.'. Error code: EntityUserFailure. (Request ID: 044c1adb-075a-4424-b77e-1d9d731718d1).

    I have a fabric capacity FYI not Powerbi premium