Applies to Product - Dynamics 365 Finance
What’s happening?
When exporting the exposed entity "mserp_dimensionsetentity" to a Synapse workspace, the exported partition ID is unexpectedly set to "0001" instead of the anticipated "2024".
Reason:
The PartitionId value is determined based on the "CreatedOn" field of the entity. If the entity has a valid "CreatedOn" value in the source data, the PartitionId will reflect that value (e.g., "2024"). However, if the entity does not have a "CreatedOn" value, the PartitionId defaults to a predefined value, such as "0001".
Resolution:
To resolve or clarify this behavior:
- Verify the "CreatedOn" field values for the entity in question.
- If the "CreatedOn" field is missing or not populated, the PartitionId will default to a predefined value such as "0001" or "1900". This is the expected behavior.
- Ensure that the source data includes a valid "CreatedOn" value if a specific partition ID (e.g., "2024") is required.