I have a dataset that refreshes nightly and taps into 6 SharePoint based Excelf files and one OData (connected to a SharePoint list). Way more often than not, the dataset won't refresh due to a credentialing issue.
Error: Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.
Within Data Source Credentials, when I click "Edit Credentials", this is the error:
Failed to update data source credentials: Access Denied. Before opening files in this location, you must first add the web site to your trusted sites list, browse to the web site, and select the option to login automatically.
But - not possible in Chrome and I can't add specifics sites to the safelist in IE due to company policy (and I can navigate to those sites just fine)
hey, this happend often around here, try setting the source to the root sharepoint instead of the specific site also you need to include the entire adrees: including the httpl:\\ from the begining. try those 2 part and let us know,
if this solved your question give some kudos and mark as solution for others to find.