Hi everyone, I'm experiencing an issue finalising a dataflow that is running a merge query on an SQL data source and the Dynamics 365 Contacts table. I can build the dataflow without any issue, which is successfully matching IDs on a non-primary ID column value that exists on both tables, and then preview the results from the merge query which retains the related D365 contactid (GUID) value in the merged table.
However, after successfully publishing the dataflow I am unable to refresh it, no data comes through into the target (merged) table and it produces a very unhelpful error:
"There was a problem refreshing the dataflow. Please try again later. (Request ID: ecdaa57c-8a7b-4880-ae79-1dfa9c06d820)."
Another odd behaviour which may be completely unrelated, is when re-opening the SQL connection inside the dataflow and either cancel the action or enter the credentials, I receive a warning:
"ResizeObserver loop completed with undelivered notifications."
Any help would be much appreciated!

Report
All responses (
Answers (