
I'm attempting to implement the Export to Data Lake from D365 to Data Lake storage.
So far I've been able to create about 26 base tables from D365 to Azure synapse as External Tables and query them with out any problems. There are two base tables where I've seen double quotes inside an address or name column, causes the external reference to that base table to fail with a "Could not find a delimiter after string delimiter."
data looks like so:
So the data exports correctly it seems but the external table reference will not see this as a simple column between the comma delimiters.
Below is the File Format I'm using for the External Table:
Feel I should open a ticket with Microsoft
Any thoughts?