Failed to configure selected file

[Anonymous]

Hi all, 

Trying to connect to an excel file on sharepoint, I have access to the file, select it through Get Data and then I get the below error. Any dieas?

I have other connections working fine and have stripped this file down to a single tab / single table to conduct testing and it did not fix the error. Have also saved the document to another directory where I have othetr working conenctions and did not work either. 

Something went wrong
Failed to configure selected file
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: f7bb6021-fa49-4953-bf7f-33bd3755712d
Request ID: 17a115ab-c51a-46db-6d3c-c01f78736621
Correlation ID: 011b49a0-7bb8-a189-a264-d1621160627c
Status code: 400
Time: Wed Jun 12 2019 14:38:42 GMT+1000 (Australian Eastern Standard Time)
Version: 13.0.9703.183
Cluster URI: https://wabi-australia-southeast-redirect.analysis.windows.net

Any ideas? 

[v-shex-msft]

HI @Anonymous ,

Any specific contents/style/macro setting in your excel sheet? Did these data stored in excel or use excel connectors to get data from external datasource?
Please explain more about these to help us clarify your scenario.

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

It was a table with names, phone numbers, dates and emails. Removing the hyperlink from the emails solved the problem. Put hyperlink back in and refresh failed, took them out again and it worked.

Problem solved, just weird that it was hyperlink causing the issue.