Forum Discussion
Dataflow Pipeline Gen2 - MashupException.Error: Failed to insert a table., InnerException: We cannot
Microsoft EmployeeHi aa2703
Thanks for using Microsoft Fabric Community.
This error arises when you attempt to use the ampersand (&) operator, which is primarily for concatenation (joining text strings), on two operands with incompatible data types: a number and a record. Microsoft Fabric's data processing language (likely Power Query M) enforces type safety to prevent unexpected behavior and ensure data integrity.
Verify the data source you’re using and the transformations applied within your mashup document. Ensure that the data types are consistent and compatible. Look for any expressions involving the & operator (concatenation) and review them carefully.
Possible Causes: You're trying to combine a number with a record using &. There might be a hidden text value in a column you thought was a number.
Convert Data Types: If you intended to combine text with a number, convert the number to text first. Power BI offers functions like TEXT() to achieve this.
Please refer to the following thread for similar issue : Expression.Error: We cannot apply operator & to ty... - Microsoft Fabric Community
I hope this informatio helps. Please do let us know if you have any further querires.
Thank you.
I will have a look at it. The funny thing is that if i set the destination to Lakehouse. Everything works just fine... Is Warehouse stricter when ingesting data into it?
- v-cboorla-msft
Hi aa2703
We haven’t heard from you on the last response and was just checking back to see if your query got answered. Otherwise, will respond back with the more details and we will try to help.
Thanks.
- v-cboorla-msft
Hi aa2703
We haven’t heard from you on the last response and was just checking back to see if your query got answered. Otherwise, will respond back with the more details and we will try to help.
Thanks.
