We have a dashboard of KPIs that we update weekly. See
I’m adding a KPI to the dashboard and so I have modified the CommCare
export to include the additional properties I need to calculate the new
KPI. This seems to have changed the url of the CommCare export file. So my
Excel dashboard file no longer works.
I have deleted the old connection within Excel and now I’m trying to create
a new one using the new url.
To do this I’m using Data>New Query>From Other Sources>From Web>paste in
I enter my CommCareHQ ID and Password and I get a 'User not authorized’