Deleted cases shown in dataset drawn by excel power query

Hi!

I have an excel linkage with KOBO data using excel power query. I have deleted some data from the KOBO data table. But in the excel power query deleted data also showing. How can I resolve this problem in KoboToolbox|?

Regards.

Hi @silasdasgupta,

Welcome to the community! Once you have synced your data to excel power query from the KoBoToolbox server, you will need to refresh the excel file (by clicking at Data>Refresh All) to see the exact data (i.e. the edited data) that is in the KoBoToolbox server.

For details, please see the last paragraph of the support article: Pulling your data into Excel Power Query.

GOOD DAY!

Hi dear Kal Lam:
Thank for your response. I have tried it (refresh all), also created a new excel file but results is same. I am not sure why it is not working.

Regards.

Hi @silasdasgupta,

How many deleted data do you currently see in your Excel file (that is not there in the server)? Also please let us know the server (OCHA or HHI) that you are using.

GOOD DAY!

Hi! @Kal_Lam:
Sorry to bother you again. Now I have checked and found that after entering another data via mobile device the deleted data has gone from the excel sheet. Now my problem is solved.

Thanks you so much to giving me your time.

Have a blessed day.

1 Like