Excel database linked to KoBo won't refresh the data set

[emirsulejmanovic]

A part of my colleague’s handover was transferring all databases to myself. Everything was working until last week when our biggest database stopped and I was unable to refresh the dataset to pull new data from KoBo. It kept giving me an error regarding credentials, however, I have checked and everything seems to be fine. I believe that it might have something to do with the Data Source. The version my database kept pulling data from has “v1” in the link, and going through KoBoToolbox Building API, I found that the link now has “v2” in the link.

[hakan_cetinkaya]

Hi @emirsulejmanovic, indeed the api end-point updated to v2.

You can check the updated help articles:

• Connecting to your data using synchronous exports — KoboToolbox documentation
• Connecting KoboToolbox to Microsoft Excel — KoboToolbox documentation

[emirsulejmanovic]

If I change the data source in the database, will it affect the rest of the data in the sheet?

[Kal_Lam]

@emirsulejmanovic, maybe you could try to make a fresh connection as advised by @hakan_cetinkaya.

[emirsulejmanovic]

The existing connection I have is the query in the workbook, which is failing to refresh and is giving me a data source error. Does changing the connection mean changing the query in this case? Do you have a step-by step guide on the connections?

[Kal_Lam]

@emirsulejmanovic, does it fail to refresh when you add or remove some questions to your survey? If this is the case, maybe you could follow the solution provided in one of our posts:

Power query: not all content is allowed to run

For other users : I’ve solved this! The query doesn’t automatically extend the number of columns it can refer to if you add questions, so if your survey started with 10 questions, the number of columns in your query will remain as 10. You need to go into the source step of your query, then find the code reference to ‘Columns = X’, and whatever number X is, replace it with the correct number so that the query registers all columns in the dataset.