We have a dashboard of KPIs that we update weekly. See
KYTS Dashboards - ColaLife.
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
url
(https://www.commcarehq.org/a/colalife/data/export/custom/dailysaved/download/cf677cd5a7b75703c44da6bda3b6d022/)
I enter my CommCareHQ ID and Password and I get a 'User not authorized'
error.
Help!
Thanks
Simon