Data Import and Ingestion Issues in Microsoft for Sustainability

Applies to Product - Microsoft Cloud for Sustainability

What’s happening?
Customers are experiencing difficulties with data import and ingestion into specific tables within Microsoft for Sustainability, particularly with the msdyn_generatedenergy table and when exporting large datasets.

Reason:

• The error message indicates that the msdyn_generatedenergy entity does not contain the attribute msdyn_organizationalunitid, which is case-sensitive.
• Timeout issues have been reported when attempting to export large datasets, particularly when the number of records exceeds 10,000.
• This may be related to auditing settings in the environment.

• For issues related to the msdyn_generatedenergy table, ensure that the auditing settings are configured correctly. Navigate to your environment, select Settings -> Audit and logs -> Audit Settings, and make sure Start Auditing is unchecked.
• If exporting large datasets, consider breaking down the data into smaller batches to avoid timeout errors.
• For intermittent issues with data ingestion, it may be necessary to review the network logs for any related errors during the ingestion process.
• If the problem persists, further investigation may be required, including checking for updates or changes in the data model that could affect the ingestion process.