ERROR IN SAVE & RUN

[nknwn]

Validation is OK but when I make save & run it show this error:

Query_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: The value does not support versioning. Details: Reason = Expression.Error;ErrorCode = 10855;Detail = #table({"id", "start_time", "completation_time", "email", "name", "correo_uninorte", "codigo_estudiantil", "fecha_de_activacion", "competencia_trabajada", "modalidad", "nombre_profesor", "programa_academico", "programa_academico_2", "enfoque", "Source.Name"}, {});Microsoft.Data.Mashup.Error.Context = User". Error code: 104100. (Request ID: 6d35f9ee-7701-4859-8553-d51c68caf859).

What happend?

[tayloramy · Accepted solution]

Hi @nknwn, 

Can you give us more details?  

Where are you seeing this error? Is this in Power BI? Is this a dataflow gen 2? 

THis appears to be a power query error, what data types are you using? Can you share the structure of your table? 

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

[Zanqueta]

hi @nknwn,

This error indicates that Power Query was unable to process the write operation to the destination because the structure of the table created in the Mashup does not support versioning (an internal service requirement). The message Expression.Error: The value does not support versioning typically appears when:

• The final step in Power Query returns an empty table (#table(...) , {}).
• Or the table structure is not correctly defined for the destination (for example, Lakehouse, Warehouse, or Dataflow).

Why does this happen?

The error snippet shows:

#table({"id", "start_time", "completation_time", ...}, {})

This means a table is being created with defined columns but no rows. When attempting to write to the destination, the service cannot apply metadata because there is no data to validate.

If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.

[nknwn]

And how can I solve this? I use dataflow gen 2 server. I am in the browser. But my table is not empty, I see it in the data view

[Zanqueta]

could you give us a print screen (hiden personal information) about your previsou step to better clariry the scenario? 

[tayloramy · Accepted solution]

Hi @nknwn, 

Are all the data types Text? I would assume that fields like Start_time would be a datetime column no? 

I see you're trying to write to SharePoint, what happens if you instead try to write the data to a lakehouse? 

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

[tayloramy · Accepted solution]

Hi @nknwn, 

Can you give us more details?  

Where are you seeing this error? Is this in Power BI? Is this a dataflow gen 2? 

THis appears to be a power query error, what data types are you using? Can you share the structure of your table? 

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

[nknwn]

Awesome! Really thanks!

[nknwn]

Is dataflow gen 2. I dont nknow where is the erro to be honest. The columns have text type