Dataflow Pipeline Gen2 - MashupException.Error: Failed to insert a table., InnerException: We cannot

[aa2703]

I'm getting this error when trying to import a few tables from a MySQL database? Based on the error it's not really clear what the problem is. It fails randomly og different tables with this error. What could be the issue?

custom_schema.order: Error Code: Mashup Exception Expression Error, Error Details: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: Failed to insert a table., InnerException: We cannot apply operator & to types Number and Record., Underlying error: We cannot apply operator & to types Number and Record. Details: Reason = Expression.Error;Message = We cannot apply operator & to types Number and Record.;Detail = [Operator = "&", Left = 2, Right = [...]];Message.Format = We cannot apply operator #{0} to types #{1} and #{2}.;Message.Parameters = {"&", "Number", "Record"};Microsoft.Data.Mashup.Error.Context = System GatewayObjectId: xxxx (Request ID: xxxx).

[v-cboorla-msft]

Hi @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.

[aa2703]

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.