Dataflow Gen2, MashupException.Error · Learn Microsoft Fabric

Dataflow Gen2, MashupException.Error

Hi everyone,

I'm new to Fabric and try some basic experience.

Now, I try to create a warehouse in Fabric as truncated from Microsoft AdventureWorksDW.

I want to create a table Product using Dataflow Gen2 from 3 tables from AdventureWorksDW: DimProduct, DimProductSubcategory, DimProductCategory.

I need only few fields: ProductKey, Color, EnglishProductName, EnglishProductSubcategoryName and EnglishProductCategryName. I setup Dataflow to return such table.

I created the table in my schema with column names above and needed datatypes (ProductKey - int, other - varchar) using SQL and set Data destination in Dataflow Gen2 to that table.

When Dataflow published and run, it is failed with error: Mashup Exception Data Source Error Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: DataSource.Error: Microsoft SQL: String or binary data would be truncated (see attached picture).

On https://community.fabric.microsoft.com/t5/Dataflows/Couldn-t-refresh-the-entity-because-of-an-issue-with-the-mashup/m-p/3514804 I found similar question, but solution is a little crazy and does not work for me.

Q: Has anyone else had such error? How to handle it?

Thank you!

2 comments