I deleted some submission of a form using the Data Table window on kobo.humanitarianresponse.info. The deleted submissions were from a previous version of this form. The submissions were successfully deleted, as they no longer show up in the Data Table view.
I have an excel workbook which pulls data using Power Query from the server. However, these deleted submission continue to appear in my Excel workbook. What is the problem?
I am stuck and cannot proceed further in my analysis work? Kindly help.
This is because your Excel Dataset synced with KoBoToolbox requires manual refresh (to get the latest records from the server). Hence for this, press the Refresh All which you should see under the Data as shown in the image below:
After several refreshes to get the data updated, i gave up. i even tried pulling data into a new fresh workbook to see if that could help. but to no avail.
Just a query (so that it is easier to better understand the issue), did you upload the survey project from the project legacy or from the KoBoToolbox Form Builder User Interface?
Have you tried making the data public (in KoBoToolbox) and then refreshing your Excel sheet as instructed above. Please let us know if it still does not work.
Today as i opened the excel, and refreshed the query, the data has got updated. Thank you. The project was already public as I guess can be seen from the below pic
Any potential tips on something you might have done to help make data disappear? I’ve tried a number of things including clearing my excel and web browser caches, but nothing seems to be working. Data still seems to be showing on my spreadsheet.
