Hi Experts,
I hope you are doing well.
I am trying to export the Entity Store (AxDW) data into Azure Data Lake. The setup has been completed and is working fine overall; however, for specific aggregate measures, an error is appearing on the Entity Store logs screen.
Error details:
"FOR XML could not serialize the data for node 'NoName' because it contains a character (0x0002) which is not allowed in XML. To retrieve this data using FOR XML, convert it to binary, varbinary or image data type and use the BINARY BASE64 directive."
Do you have any suggestions on how to fix or debug this issue?
Thank you in advance for your help.
MS Official Documentation I followed: https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/entity-store-data-lake
Screenshot:

Report
All responses (
Answers (