I am encountering an “External Data Range” error when refreshing data in an Excel workbook linked to a KoboToolbox project via Power Query. Since other Excel files are functioning correctly, the issue may be related to changes in the KoboToolbox form or its data structure.
Could you please advise on how to verify and resolve this issue? I would be happy to provide additional details if needed.
Welcome back to the community, @amritshakya! Could you please verify if there have been any updates to your form that include new questions (variables)? If there are updates, you will also need to adjust the corresponding query when connecting your data to Excel. Making these changes should resolve your issue. We look forward to hearing the outcome.
Thank you so much, @Kal_Lam, for getting back to me. Yes, there was an update (a new question) in the form. I restarted the process from the beginning; however, the issue is still persisting. Could you please guide me on how to adjust the corresponding query, in case I may have missed any steps?
Additionally, the username of the enumerator was collected in the latest version. Could this be the reason?
Hi, I’m just following up on the issue.@Kal_Lam
