Couldn't refresh the entity because of an issue with the mashup document

[fbrodrigues95]

Hi , 

I am new with MS Fabric, contiuously practicing and able to create a dataflowgen2 with data destination warehouse. 

Now I have a dataflowgen2 that will create a new table based on the data from datasource. After doing the data transformation and load to the warehouse i am getting this error "Error Details: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: DataFormat.Error: Failed to insert a table., InnerException: We couldn't convert to Number., Underlying error: We couldn't convert to Number. Details: Reason = DataFormat.Error;Message = We couldn't convert to Number.;Detail = ,;Message.Format = We couldn't convert to Number.;Microsoft.Data.Mashup.Error."

I try to connect to a different lakehouse, try do disable staging but still getting the same error message.

Can anyone help me understand what im doing wrong?

[miguel · Accepted solution]

it appears that one of your transformations has a changed type where it tries to transform data to a number, but it cannot for some values. That's why you have the error below:

We couldn't convert to Number., Underlying error: We couldn't convert to Number. 

You should check your number columns to see if you have any errors in them.

[v-cboorla-msft]

Hi @fbrodrigues95 

Glad that your query got resolved.

Please continue using Fabric Community for any help regarding your queries.

Thanks.