sharepoint online – Unable to refresh data from Excel documents

I have a library in SharePoint Online. When on the library I use the Export to Excel button within the tab.

This downloads the query file which I open, after this I click enable on the security notice to enable content.

This then displays the data from the library. However when I press refresh

enter image description here

I receive the following error message:
enter image description here

I am able to export and refresh other libraries in the same manner on the tenancy. I currently have full control access to the data.
When looking at the connection properties they are the same as a user who is currently able to complete the above.

The parent site above the library has recently had a name/url change.