Views:

Applies to Product -  Power Automate


What’s happening?
The content field in Dataverse (Conversation Transcript) contains secured data, and there is a need to truncate or hide this sensitive information.
 

Reason:
Power Automate is intended for small-scale updates and is not suitable for updating large-scale data (millions or tens of millions of Dataverse records) due to limitations in batch processing performance, strict API request limits, and inefficient handling of high-scale concurrent operations.
 

Resolution:

  1. Utilize the preview feature to create and manage masking rules. This can help meet the requirement to mask specific fields and sensitive information within the Content column.
  2. Enable column security and select a masking rule to mask sensitive information from the Conversation Transcript column.
  3. For large-scale updates, consider alternative solutions such as:
-Azure Data Factory (ADF) with Dataverse Connector for efficient bulk data loads.
-Dataverse Bulk API (Batch Requests) for direct API calls from a script with higher throughput.