Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
Solved! Go to 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.
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.
Glad that your query got resolved.
Please continue using Fabric Community for any help regarding your queries.
Thanks.
Check out the September 2024 Fabric update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.