topic Re: Couldn't refresh the entity because of an issue with the mashup document in Dataflow

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

fbrodrigues95 — Wed, 21 Feb 2024 12:56:50 GMT

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?

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

miguel — Wed, 21 Feb 2024 16:19:51 GMT

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.

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

v-cboorla-msft — Thu, 22 Feb 2024 06:40:51 GMT

Hi fbrodrigues95

Glad that your query got resolved.

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

Thanks.