I created a integration data project that import data from D365FO to CDS
everything run smoothly
after, I needed to add new column in my import.
however, after running the import project again, my new columns are not populated
I believe the "version" column might be the reason why the upsert do not refresh my data, as I believe the version will be same.
is Data integration used version column to determine if record need to be updated / inserted ?!
I notice following message
as a way to force refresh of records, is there a way to remove all Entity records from the PowerApps web page / withouth having to developer a PowerApps to do soe. something similar to truncate SQL command
Solved! Go to Solution.
Hi @sang73 ,
Do you create a Data Integration Project to sync data from your D365FO to CDS Entity?
Do you add some new columns in your Import, and want these values populated into your CDS Entity?
It is an known issue that the added new columns within the "Import" progress would not take effect within the existing Data Integration Project task.
As an alternative solution, please consider remove the the existing task within your Data Integration Project, then click "Add task" button to add a new task in your Data Integration Project to execute the import process from your D365FO to CDS Entity:
then within the new added Task, re-specify the fields mapping as below:
then run the Data Integration Project task again, check if the issue is solved.
In addition, if you want to remove all records from your CDS Entity without creating a PowerApps app, I think the "Edit data in Excel" functionality in your CDS Entity could achieve your needs:
you could click the "Edit data in Excel" functionality in your CDS Entity, then it would open your CDS Entity records within a Excel file, then you could remove all records from the Excel table, then click "Publish" button, after that, all records would be deleted:
More details about "Edit data in Excel" functionality in CDS Entity, please check the following article:
Hi @sang73 ,
Is the solution I provided above is helpful in your scenario?
If the solution ("Edit data in Excel" functionality in CDS Entity) I provided above is helpful in your scenario, please consider go ahead to click "Accept as Solution" to identify my solution as "Solved".
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand