Hi.
I have an Excel file pulling data from multiple Kobo projects. I have archived some of these projects and in my Power Query, I have one where I’m pulling data from multiple connections (Archived and Unarchived ones). now I cannot edit my queries or refresh my connections because the API endpoint does not work when the project is archived. I am using the API V1.
In some cases, I just want to make some calculations in my query and I don’t want to unarchive these projects.
I have found one other topic from 2021 having the same issue without solutions.
Thanks
