I am facing an issue with a Dataflow in Dataverse / Power Platform where the data is visible correctly in the Dataflow preview and source table, but some records are not getting updated or inserted into the target table.
Issue Details:
- Source data is coming from a Virtual Table / Business Central entity.
- Dataflow refresh completes successfully without errors.
- Mapping is properly configured.
- Preview shows all records correctly, including the missing Item Numbers.
- However, a few specific records are not appearing in the target Dataverse table after refresh.
- Most records sync correctly; issue occurs only for certain items/orders.
Things already checked:
- Primary key and alternate key mappings.
- No filters excluding the records.
- Source records exist correctly.
- Dataflow was refreshed and republished multiple times.
- Target table permissions and mappings look fine.
Has anyone experienced a similar issue where the Dataflow preview shows the data correctly, but the target Dataverse table does not update for certain records?
Any suggestions or troubleshooting guidance would be appreciated.

Report
All responses (
Answers (