Problems linking an Excel (Office 365) Dashboard to the data source on CommCareHQ

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’