Dataflow (Gen2) Error in replacing table's content with new data in a version: #{0}., InnerException

[Don-Bot]

I have a dataflow gen 2 that is connecting to a salesforce object and then trying to write it to a lakehouse table.  I am getting this message...  it runs fine in the dataflow and previews the data just fine.  But I can't seem to figure out why it won't write the data to the lakehouse.  

I also tried deleting the existing table and having it create a new one.

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 0 to type Function. Details: Reason = Expression.Error;ErrorCode = Lakehouse036;Message = We cannot convert the value 0 to type Function.;Message.Format = We cannot convert the value #{0} to type #{1}.;Message.Parameters = {"0", "Function"};ErrorCode = 10277;Microsoft.Data.Mashup.Error.Context = User'. Error code: Mashup Exception Expression Error. (Request ID: 0e370230-7ef6-4be2-9188-e27f27f7ee06).

[v-venuppu]

Hi @Don-Bot ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

[v-venuppu]

Hi @Don-Bot ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @tayloramy for the prompt response.

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.

[tayloramy]

Hi @Don-Bot 

That error means the dataflow is trying to write a column whose values are not a supported primitive type for Lakehouse tables. In your case, the message "We cannot convert the value 0 to type Function" points to a column that ended up with values of type Function (often from a custom step that returns a function instead of invoking it). Lakehouse tables only accept primitive types (text, number, datetime, etc.) and explicitly do not support Function, List, Record, or Table values as column values. See supported types and destination behavior in Microsofts doc: Dataflow Gen2 data destinations and managed settings.

Quick solution

1. In Power Query Online, verify every column is a primitive type before the destination step. Expand or convert any List/Record columns and remove any columns whose values are Function.
2. If you are landing in an existing table, align data types and nullability to the destination. If necessary, temporarily switch to Replace with dynamic schema or recreate the table after fixing types.
3. For Salesforce specifically, expand relationship and complex fields (they often come in as Records or Lists) and cast to nullable primitive types.
4. Republish the dataflow and reconfigure the destination mapping if you changed schema.

Common Salesforce gotchas
Relationship columns like Owner, CreatedBy, Account often arrive as Record. Use the expand icon to select fields like Owner.Id or Owner.Name.
Multi-select picklists or arrays can arrive as List. Expand to rows or transform to text (for example, Text.Combine(List.Transform([YourList], each Text.From(_)), ",")).
Connector references: Salesforce Objects connector in Fabric and general Power Query connector notes: Power Query Salesforce Objects.

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.