Applies to Product - Power Apps
What’s happening?
Customers are experiencing issues with dataflows in Dataverse, including data format errors when converting to numbers and problems with fields not being ingested correctly. Additionally, there are concerns regarding the accuracy of exported data formats, particularly with large, encoded images and junk data.
Reason:
- The data format error may arise from a mismatch between the data types in the source and target columns, leading to conversion failures.
- Large encoded images may exceed cell size limitations during export, causing truncation or inaccuracies in the exported data.
- Junk data may appear in exported files due to incorrect mappings or transformations in the dataflow.
Resolution:
- For data format errors, verify the data types of the source and target columns to ensure they match. Review any unnecessary symbols in the records that could cause conversion issues.
- If large images are causing export issues, consider exporting the data without the photo column or using alternative methods such as Power Automate to save images to a document library.
- For fields not being ingested, check the mappings in the dataflow and ensure that all required fields are correctly configured.
- If issues persist, create a new dataflow with the same functionality to see if it resolves the problem.
- If this remains unresolved, gather additional information about the dataflow, including execution logs and any error messages, and contact Microsoft Support for further investigation.