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!

Welcome to all new members, here's some links and information to help you get started! 𝗤𝘂𝗶𝗰𝗸 𝗟𝗶𝗻𝗸𝘀 𝘁𝗼 𝗴𝗲𝘁 𝘀𝘁𝗮𝗿𝘁𝗲𝗱 - For an introduction to this community → Explore the Welcome Pack - New-ish to Fabric? → Check out our Fabric Foundation module - Studying for the DP-600? → Check out the DP-600 Module and the DP-600 category - Studying for the DP-700? → Check out the DP-700 Module and the DP-700 category - Want to get hands-on? → Check out Fabric Dojo 𝗛𝗼𝘄 𝘁𝗼 𝗲𝗻𝗴𝗮𝗴𝗲 𝘄𝗶𝘁𝗵 𝘁𝗵𝗲 𝗰𝗼𝗺𝗺𝘂𝗻𝗶𝘁𝘆? - Share your knowledge and experience! Even if you're relatively new to Fabric, or the community, your opinion and experiences are valued here! A great way to earn your first point(s) is to introduce yourself in the thread below 👇😀 Thank you for engaging and joining us on this exciting learning journey! 🙏 Will