Forum Discussion
Expression.Error: We cannot apply operator & to types Number and Record
I also experience this same error and it does appear to be random in nature. My data originates in on premises SQL Server, so I don't think it is related to Postgres as suggested elsewhere.
In fact, the latest instance of this error for me is against my central date dimension table which is created entirely within Fabric from a Power M script.
I do not explictly do what the error message describes, so I believe it is a consequential error from something internal.
I did revisit some of the dataflows (gen2) that were failing and when I explored the destination details, it had the message about some of the data types having changed, but they hadn't.
I'm afraid I have no concrete suggestions other than I have found that revisiting a dataflow and re-confirming the destination details "can" help.
Hi EcurieArgyll. see my post above to this post.
This problem appears to be related to the 2024 April version of the gateway. My team downgraded the gateway to the 2024 February version and that solved the problem. And based on the post I linked to, installing the May version also fixes this problem.