I need advice how I can fix problem with Excel external data connection.
I have an excel file, which have connection to SSAS. Excel file "refresh all" works fine if I download it out from SharePoint. However, if I try use file in excel services it gives me an error message: "External Data Refresh Failed".
I have tried various fixes, what I could find in google but no luck. What I have tried:
I have add libraries:
Manage Excel Services Application
Trusted File Locations
Trusted Data Connection Libraries
I tried with connection file and without. External Data Refresh Failed - which setting is causing this error
So, what next? Any clues / tips, what I should try next? I appreciate any help.